Skip to content

Commit 118ee98

Browse files
mattmakaimattmakai
committed
adding new postgresql resources
1 parent 88a7654 commit 118ee98

4 files changed

Lines changed: 35 additions & 24 deletions

File tree

‎all.html‎

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -3107,6 +3107,14 @@ <h3>PostgreSQL resources</h3>
31073107
<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>
31083108
for many use cases.</p>
31093109
</li>
3110+
<li>
3111+
<p>If you're just getting started with PostgreSQL here are
3112+
<a href="https://eye.raze.mx/10-beginner-postgresql-tasks-you-should-know/">10 beginner tasks you should know how to execute</a>.</p>
3113+
</li>
3114+
<li>
3115+
<p>The title's a bit presumptuous but here's a useful list of
3116+
<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>
3117+
</li>
31103118
</ul>
31113119
<h2>MySQL</h2>
31123120
<p>MySQL is another viable open source database backend option for Python web
@@ -3189,7 +3197,7 @@ <h2>Database third-party services</h2>
31893197
databases with extensive backup services.</p>
31903198
</li>
31913199
</ul>
3192-
<h2>Database resources</h2>
3200+
<h2>General database resources</h2>
31933201
<ul>
31943202
<li>
31953203
<p><a href="http://coding-geek.com/how-databases-work/">How does a relational database work?</a>
@@ -3204,11 +3212,6 @@ <h2>Database resources</h2>
32043212
the time to read.</p>
32053213
</li>
32063214
<li>
3207-
<p><a href="http://www.pg-versus-ms.com/">PostgreSQL vs. MS SQL Server</a> is one
3208-
perspective on the differences between the two database servers from a
3209-
data analyst.</p>
3210-
</li>
3211-
<li>
32123215
<p><a href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular
32133216
database management systems.</p>
32143217
</li>
@@ -3226,8 +3229,9 @@ <h2>Database resources</h2>
32263229
covers a difficult topic that comes up on every real world project.</p>
32273230
</li>
32283231
<li>
3229-
<p>The title's a bit presumptuous but here's a useful list of
3230-
<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>
3232+
<p><a href="http://www.pg-versus-ms.com/">PostgreSQL vs. MS SQL Server</a> is one
3233+
perspective on the differences between the two database servers from a
3234+
data analyst.</p>
32313235
</li>
32323236
</ul>
32333237
<h2>Databases learning checklist</h2>

‎databases.html‎

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -118,6 +118,14 @@ <h3>PostgreSQL resources</h3>
118118
<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>
119119
for many use cases.</p>
120120
</li>
121+
<li>
122+
<p>If you're just getting started with PostgreSQL here are
123+
<a href="https://eye.raze.mx/10-beginner-postgresql-tasks-you-should-know/">10 beginner tasks you should know how to execute</a>.</p>
124+
</li>
125+
<li>
126+
<p>The title's a bit presumptuous but here's a useful list of
127+
<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>
128+
</li>
121129
</ul>
122130
<h2>MySQL</h2>
123131
<p>MySQL is another viable open source database backend option for Python web
@@ -200,7 +208,7 @@ <h2>Database third-party services</h2>
200208
databases with extensive backup services.</p>
201209
</li>
202210
</ul>
203-
<h2>Database resources</h2>
211+
<h2>General database resources</h2>
204212
<ul>
205213
<li>
206214
<p><a href="http://coding-geek.com/how-databases-work/">How does a relational database work?</a>
@@ -215,11 +223,6 @@ <h2>Database resources</h2>
215223
the time to read.</p>
216224
</li>
217225
<li>
218-
<p><a href="http://www.pg-versus-ms.com/">PostgreSQL vs. MS SQL Server</a> is one
219-
perspective on the differences between the two database servers from a
220-
data analyst.</p>
221-
</li>
222-
<li>
223226
<p><a href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular
224227
database management systems.</p>
225228
</li>
@@ -237,8 +240,9 @@ <h2>Database resources</h2>
237240
covers a difficult topic that comes up on every real world project.</p>
238241
</li>
239242
<li>
240-
<p>The title's a bit presumptuous but here's a useful list of
241-
<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>
243+
<p><a href="http://www.pg-versus-ms.com/">PostgreSQL vs. MS SQL Server</a> is one
244+
perspective on the differences between the two database servers from a
245+
data analyst.</p>
242246
</li>
243247
</ul>
244248
<h2>Databases learning checklist</h2>

‎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>2015-09-09T12:56:08Z</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>2015-09-10T15:13:52Z</updated></feed>

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

Lines changed: 10 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -94,6 +94,12 @@ The post is an inside look at the evolution of Braintree's usage of the database
9494
* This article explains how and why PostgreSQL can handle [full text searching](http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/)
9595
for many use cases.
9696

97+
* If you're just getting started with PostgreSQL here are
98+
[10 beginner tasks you should know how to execute](https://eye.raze.mx/10-beginner-postgresql-tasks-you-should-know/).
99+
100+
* The title's a bit presumptuous but here's a useful list of
101+
[7 PostgreSQL data migration hacks you should be using, but aren't](http://engineering.tilt.com/7-postgresql-data-migration-hacks/).
102+
97103

98104
## MySQL
99105
MySQL is another viable open source database backend option for Python web
@@ -170,7 +176,7 @@ provider.
170176
databases with extensive backup services.
171177

172178

173-
## Database resources
179+
## General database resources
174180
* [How does a relational database work?](http://coding-geek.com/how-databases-work/)
175181
is a detailed longform post on the sorting, searching, merging and other
176182
operations we often take for granted when using an established relational
@@ -181,10 +187,6 @@ provider.
181187
that are at the core of database theory and implementation. Well worth
182188
the time to read.
183189

184-
* [PostgreSQL vs. MS SQL Server](http://www.pg-versus-ms.com/) is one
185-
perspective on the differences between the two database servers from a
186-
data analyst.
187-
188190
* [DB-Engines](http://db-engines.com/en/ranking) ranks the most popular
189191
database management systems.
190192

@@ -198,8 +200,9 @@ provider.
198200
* [Databases integration testing strategies](https://julien.danjou.info/blog/2014/db-integration-testing-strategies-python)
199201
covers a difficult topic that comes up on every real world project.
200202

201-
* The title's a bit presumptuous but here's a useful list of
202-
[7 PostgreSQL data migration hacks you should be using, but aren't](http://engineering.tilt.com/7-postgresql-data-migration-hacks/).
203+
* [PostgreSQL vs. MS SQL Server](http://www.pg-versus-ms.com/) is one
204+
perspective on the differences between the two database servers from a
205+
data analyst.
203206

204207

205208
## Databases learning checklist

0 commit comments

Comments
 (0)