Skip to content

Commit 4707dbc

Browse files
mattmakaimattmakai
committed
working on postgresql page
1 parent 15eb1c1 commit 4707dbc

6 files changed

Lines changed: 62 additions & 29 deletions

File tree

‎all.html‎

Lines changed: 21 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -3814,6 +3814,10 @@ <h2>General database resources</h2>
38143814
the time to read.</p>
38153815
</li>
38163816
<li>
3817+
<p><a href="http://www.craigkerstiens.com/2016/01/08/writing-better-sql/">Writing better SQL</a>
3818+
is a short code styling guide to make your queries easier to read.</p>
3819+
</li>
3820+
<li>
38173821
<p><a href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular
38183822
database management systems.</p>
38193823
</li>
@@ -4495,7 +4499,8 @@ <h2>Connecting to PostgreSQL with Python</h2>
44954499
driver, which is also referred to as a database connector. The most common
44964500
driver library for working with PostgreSQL is
44974501
<a href="http://initd.org/psycopg/">psycopg2</a>.</p>
4498-
<p>In addition to the database driver, many Python developers use an
4502+
<p>To abstract the connection between tables and objects, many Python
4503+
developers use an
44994504
<a href="/object-relational-mappers-orms.html">object-relational mapper (ORM)</a> with
45004505
to turn relational data from PostgreSQL into objects that can be used in
45014506
their Python application. For example, while PostgreSQL provides a
@@ -4550,8 +4555,10 @@ <h3>PostgreSQL resources</h3>
45504555
during a query.</p>
45514556
</li>
45524557
<li>
4553-
<p>This article explains how and why PostgreSQL can handle <a href="http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/">full text searching</a>
4554-
for many use cases.</p>
4558+
<p>This article explains how and why PostgreSQL can handle
4559+
<a href="http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/">full text searching</a>
4560+
for many use cases. If you're going down this route, read
4561+
<a href="http://blog.garage-coding.com/2015/12/18/postgres-fulltext-search.html">this blog post that explains how one developer implemented PostgreSQL full text search with SQLAlchemy</a>.</p>
45554562
</li>
45564563
<li>
45574564
<p>If you're just getting started with PostgreSQL here are
@@ -4562,8 +4569,13 @@ <h3>PostgreSQL resources</h3>
45624569
<a href="http://engineering.tilt.com/7-postgresql-data-migration-hacks/">7 PostgreSQL data migration hacks you should be using, but aren't</a>.</p>
45634570
</li>
45644571
<li>
4565-
<p>This guide to
4566-
<a href="http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/">PostgreSQL monitoring</a>
4572+
<p><a href="https://github.com/dhamaniasad/awesome-postgres">awesome-postgres</a>
4573+
is a list of code libraries, tutorials and newsletters focused
4574+
specifically on PostgreSQL.</p>
4575+
</li>
4576+
<li>
4577+
<p>This
4578+
<a href="http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/">guide to PostgreSQL monitoring</a>
45674579
is handy for knowing what to measure and how to do it.</p>
45684580
</li>
45694581
<li>
@@ -4572,15 +4584,15 @@ <h3>PostgreSQL resources</h3>
45724584
<a href="http://phili.pe/posts/postgresql-on-the-command-line/">comfortable with the command-line interface</a>.</p>
45734585
</li>
45744586
<li>
4575-
<p>Backing up databases is important because data loss can and does happen. This
4576-
article explains
4587+
<p>Backing up databases is important because data loss can and does happen.
4588+
This article explains
45774589
<a href="http://www.n2ws.com/blog/how-to-backup-your-aws-cloud-based-postgresql-database.html">how to back up a PostgreSQL database hosted on an Amazon Web Services EC2 instance</a>
45784590
if managing your own database on a cloud server is your preferred setup.</p>
45794591
</li>
45804592
<li>
45814593
<p><a href="https://tech.zalando.com/blog/hack-to-terminate-tcp-conn-postgres/">How to fix undead PostgreSQL queries</a>
4582-
shows a bit of a hack for when what to do when you can't kill certain PostgreSQL
4583-
queries.</p>
4594+
shows a bit of a hack for when what to do when you can't kill certain
4595+
PostgreSQL queries.</p>
45844596
</li>
45854597
<li>
45864598
<p><a href="http://sdf.org/~riley/blog/2016/01/04/is-bi-directional-replication-bdr-in-postgres-transactional/">Is bi-directional replication (BDR) in PostgreSQL transactional?</a>

‎databases.html‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -169,6 +169,10 @@ <h2>General database resources</h2>
169169
the time to read.</p>
170170
</li>
171171
<li>
172+
<p><a href="http://www.craigkerstiens.com/2016/01/08/writing-better-sql/">Writing better SQL</a>
173+
is a short code styling guide to make your queries easier to read.</p>
174+
</li>
175+
<li>
172176
<p><a href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular
173177
database management systems.</p>
174178
</li>

‎feeds/all.atom.xml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,2 @@
11
<?xml version="1.0" encoding="utf-8"?>
2-
<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-01-22T09:15:38Z</updated></feed>
2+
<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-01-22T10:33:15Z</updated></feed>

‎postgresql.html‎

Lines changed: 17 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -67,7 +67,8 @@ <h2>Connecting to PostgreSQL with Python</h2>
6767
driver, which is also referred to as a database connector. The most common
6868
driver library for working with PostgreSQL is
6969
<a href="http://initd.org/psycopg/">psycopg2</a>.</p>
70-
<p>In addition to the database driver, many Python developers use an
70+
<p>To abstract the connection between tables and objects, many Python
71+
developers use an
7172
<a href="/object-relational-mappers-orms.html">object-relational mapper (ORM)</a> with
7273
to turn relational data from PostgreSQL into objects that can be used in
7374
their Python application. For example, while PostgreSQL provides a
@@ -122,8 +123,10 @@ <h3>PostgreSQL resources</h3>
122123
during a query.</p>
123124
</li>
124125
<li>
125-
<p>This article explains how and why PostgreSQL can handle <a href="http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/">full text searching</a>
126-
for many use cases.</p>
126+
<p>This article explains how and why PostgreSQL can handle
127+
<a href="http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/">full text searching</a>
128+
for many use cases. If you're going down this route, read
129+
<a href="http://blog.garage-coding.com/2015/12/18/postgres-fulltext-search.html">this blog post that explains how one developer implemented PostgreSQL full text search with SQLAlchemy</a>.</p>
127130
</li>
128131
<li>
129132
<p>If you're just getting started with PostgreSQL here are
@@ -134,8 +137,13 @@ <h3>PostgreSQL resources</h3>
134137
<a href="http://engineering.tilt.com/7-postgresql-data-migration-hacks/">7 PostgreSQL data migration hacks you should be using, but aren't</a>.</p>
135138
</li>
136139
<li>
137-
<p>This guide to
138-
<a href="http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/">PostgreSQL monitoring</a>
140+
<p><a href="https://github.com/dhamaniasad/awesome-postgres">awesome-postgres</a>
141+
is a list of code libraries, tutorials and newsletters focused
142+
specifically on PostgreSQL.</p>
143+
</li>
144+
<li>
145+
<p>This
146+
<a href="http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/">guide to PostgreSQL monitoring</a>
139147
is handy for knowing what to measure and how to do it.</p>
140148
</li>
141149
<li>
@@ -144,15 +152,15 @@ <h3>PostgreSQL resources</h3>
144152
<a href="http://phili.pe/posts/postgresql-on-the-command-line/">comfortable with the command-line interface</a>.</p>
145153
</li>
146154
<li>
147-
<p>Backing up databases is important because data loss can and does happen. This
148-
article explains
155+
<p>Backing up databases is important because data loss can and does happen.
156+
This article explains
149157
<a href="http://www.n2ws.com/blog/how-to-backup-your-aws-cloud-based-postgresql-database.html">how to back up a PostgreSQL database hosted on an Amazon Web Services EC2 instance</a>
150158
if managing your own database on a cloud server is your preferred setup.</p>
151159
</li>
152160
<li>
153161
<p><a href="https://tech.zalando.com/blog/hack-to-terminate-tcp-conn-postgres/">How to fix undead PostgreSQL queries</a>
154-
shows a bit of a hack for when what to do when you can't kill certain PostgreSQL
155-
queries.</p>
162+
shows a bit of a hack for when what to do when you can't kill certain
163+
PostgreSQL queries.</p>
156164
</li>
157165
<li>
158166
<p><a href="http://sdf.org/~riley/blog/2016/01/04/is-bi-directional-replication-bdr-in-postgres-transactional/">Is bi-directional replication (BDR) in PostgreSQL transactional?</a>

‎source/content/pages/05-data/02-databases.markdown‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -153,6 +153,9 @@ provider.
153153
that are at the core of database theory and implementation. Well worth
154154
the time to read.
155155

156+
* [Writing better SQL](http://www.craigkerstiens.com/2016/01/08/writing-better-sql/)
157+
is a short code styling guide to make your queries easier to read.
158+
156159
* [DB-Engines](http://db-engines.com/en/ranking) ranks the most popular
157160
database management systems.
158161

‎source/content/pages/05-data/05-postgresql.markdown‎

Lines changed: 16 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -50,7 +50,8 @@ driver, which is also referred to as a database connector. The most common
5050
driver library for working with PostgreSQL is
5151
[psycopg2](http://initd.org/psycopg/).
5252

53-
In addition to the database driver, many Python developers use an
53+
To abstract the connection between tables and objects, many Python
54+
developers use an
5455
[object-relational mapper (ORM)](/object-relational-mappers-orms.html) with
5556
to turn relational data from PostgreSQL into objects that can be used in
5657
their Python application. For example, while PostgreSQL provides a
@@ -97,31 +98,37 @@ The post is an inside look at the evolution of Braintree's usage of the database
9798
provides a fascinating look into the internal workings of PostgreSQL
9899
during a query.
99100

100-
* This article explains how and why PostgreSQL can handle [full text searching](http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/)
101-
for many use cases.
101+
* This article explains how and why PostgreSQL can handle
102+
[full text searching](http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/)
103+
for many use cases. If you're going down this route, read
104+
[this blog post that explains how one developer implemented PostgreSQL full text search with SQLAlchemy](http://blog.garage-coding.com/2015/12/18/postgres-fulltext-search.html).
102105

103106
* If you're just getting started with PostgreSQL here are
104107
[10 beginner tasks you should know how to execute](https://eye.raze.mx/10-beginner-postgresql-tasks-you-should-know/).
105108

106109
* The title's a bit presumptuous but here's a useful list of
107110
[7 PostgreSQL data migration hacks you should be using, but aren't](http://engineering.tilt.com/7-postgresql-data-migration-hacks/).
108111

109-
* This guide to
110-
[PostgreSQL monitoring](http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/)
112+
* [awesome-postgres](https://github.com/dhamaniasad/awesome-postgres)
113+
is a list of code libraries, tutorials and newsletters focused
114+
specifically on PostgreSQL.
115+
116+
* This
117+
[guide to PostgreSQL monitoring](http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/)
111118
is handy for knowing what to measure and how to do it.
112119

113120
* While you can use a graphical interface for working with PostgreSQL, it's
114121
best to spend some time getting
115122
[comfortable with the command-line interface](http://phili.pe/posts/postgresql-on-the-command-line/).
116123

117-
* Backing up databases is important because data loss can and does happen. This
118-
article explains
124+
* Backing up databases is important because data loss can and does happen.
125+
This article explains
119126
[how to back up a PostgreSQL database hosted on an Amazon Web Services EC2 instance](http://www.n2ws.com/blog/how-to-backup-your-aws-cloud-based-postgresql-database.html)
120127
if managing your own database on a cloud server is your preferred setup.
121128

122129
* [How to fix undead PostgreSQL queries](https://tech.zalando.com/blog/hack-to-terminate-tcp-conn-postgres/)
123-
shows a bit of a hack for when what to do when you can't kill certain PostgreSQL
124-
queries.
130+
shows a bit of a hack for when what to do when you can't kill certain
131+
PostgreSQL queries.
125132

126133
* [Is bi-directional replication (BDR) in PostgreSQL transactional?](http://sdf.org/~riley/blog/2016/01/04/is-bi-directional-replication-bdr-in-postgres-transactional/)
127134
explores a relatively obscure topic with the final result that BDR is
@@ -132,4 +139,3 @@ The post is an inside look at the evolution of Braintree's usage of the database
132139
tool built by Spotify's engineers that extracts and outputs metrics from
133140
an existing PostgreSQL database. There's also a way to extend the tools
134141
to pull custom metrics as well.
135-

0 commit comments

Comments
 (0)