Skip to content

Commit 78a47ef

Browse files
mattmakaimattmakai
committed
adding significant new postgres links
1 parent b2d0da5 commit 78a47ef

File tree

3 files changed

+60
-17
lines changed

3 files changed

+60
-17
lines changed

‎databases.html‎

Lines changed: 26 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -93,8 +93,30 @@ <h1>Databases</h1>
9393
file on disk. SQLite is built into Python but is only built for access
9494
by a single connection at a time. Therefore is highly recommended to not
9595
<a class="reference external" href="https://docs.djangoproject.com/en/dev/ref/databases/#database-is-locked-errors">run a production web application with SQLite</a>.</p>
96-
<div class="section" id="database-connections-with-python">
97-
<h2>Database connections with Python</h2>
96+
<div class="section" id="id1">
97+
<h2>PostgreSQL</h2>
98+
<p>PostgreSQL is the recommended relational database for working with Python
99+
web applications. PostgreSQL's feature set, active development and stability
100+
contribute to its usage as the backend for millions of applications live
101+
on the Web today.</p>
102+
<div class="section" id="postgresql-resources">
103+
<h3>PostgreSQL resources</h3>
104+
<p>This post on &quot;<a class="reference external" href="http://killtheyak.com/use-postgresql-with-django-flask/">Use PostgreSQL with Django or Flask</a>&quot;
105+
is a great quickstart guide for either framework.</p>
106+
<p><a class="reference external" href="http://postgresweekly.com/">PostgreSQL Weekly</a> is a weekly newsletter of
107+
PostgreSQL content from around the web.</p>
108+
<p><a class="reference external" href="https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution">Scaling PostgreSQL at Braintree</a>. Fascinating
109+
inside look at the evolution of the database's usage at Braintree.</p>
110+
<p><a class="reference external" href="http://www.ibm.com/developerworks/library/os-postgresecurity/">Total security in a PostgreSQL database</a>.
111+
There is no such thing as total security but this is a good article anyway.</p>
112+
<p><a class="reference external" href="http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/">Understanding PostgreSQL performance</a></p>
113+
<p><a class="reference external" href="http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram">Handling growth with Postgres</a>
114+
provides 5 specific tips from Instagram's engineering team on how to scale
115+
the design of your PostgreSQL database.</p>
116+
</div>
117+
</div>
118+
<div class="section" id="connecting-to-a-database-with-python">
119+
<h2>Connecting to a database with Python</h2>
98120
<p>To work with a relational database using Python, you need to use a code
99121
library. The most common libraries for relational databases are:</p>
100122
<p><a class="reference external" href="http://initd.org/psycopg/">psycopg2</a> for PostgreSQL</p>
@@ -121,17 +143,13 @@ <h2>Database third-party services</h2>
121143
<p><a class="reference external" href="https://developers.google.com/cloud-sql/">Google Cloud SQL</a> is a service
122144
with managed, backed up, replicated, and auto-patched MySQL instances. Cloud
123145
SQL integrates with Google App Engine but can be used independently as well.</p>
124-
</div>
125146
<div class="section" id="database-resources">
126-
<h2>Database resources</h2>
147+
<h3>Database resources</h3>
127148
<p><a class="reference external" href="http://db-engines.com/en/ranking">DB-Engines</a> ranks the most popular
128149
database management systems.</p>
129-
<p><a class="reference external" href="http://postgresweekly.com/">PostgreSQL Weekly</a> is a weekly newsletter of
130-
PostgreSQL content from around the web.</p>
131150
<p><a class="reference external" href="http://dbweekly.com/">DB Weekly</a> is a new (as of Feb 2014) weekly roundup
132151
of general database articles and resources.</p>
133-
<p><a class="reference external" href="http://www.ibm.com/developerworks/library/os-postgresecurity/">Total security in a PostgreSQL database</a>.
134-
There is no such thing as total security but this is a good article anyway.</p>
152+
</div>
135153
</div>
136154

137155
<br/>

‎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>2014-02-09T09:12:28Z</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>2014-02-10T07:58:55Z</updated></feed>

‎source/content/pages/databases.rst‎

Lines changed: 33 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -30,9 +30,38 @@ file on disk. SQLite is built into Python but is only built for access
3030
by a single connection at a time. Therefore is highly recommended to not
3131
`run a production web application with SQLite <https://docs.djangoproject.com/en/dev/ref/databases/#database-is-locked-errors>`_.
3232

33+
----------
34+
PostgreSQL
35+
----------
36+
PostgreSQL is the recommended relational database for working with Python
37+
web applications. PostgreSQL's feature set, active development and stability
38+
contribute to its usage as the backend for millions of applications live
39+
on the Web today.
40+
41+
PostgreSQL resources
42+
====================
43+
This post on "`Use PostgreSQL with Django or Flask <http://killtheyak.com/use-postgresql-with-django-flask/>`_"
44+
is a great quickstart guide for either framework.
3345

34-
Database connections with Python
35-
--------------------------------
46+
`PostgreSQL Weekly <http://postgresweekly.com/>`_ is a weekly newsletter of
47+
PostgreSQL content from around the web.
48+
49+
`Scaling PostgreSQL at Braintree <https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution>`_. Fascinating
50+
inside look at the evolution of the database's usage at Braintree.
51+
52+
`Total security in a PostgreSQL database <http://www.ibm.com/developerworks/library/os-postgresecurity/>`_.
53+
There is no such thing as total security but this is a good article anyway.
54+
55+
`Understanding PostgreSQL performance <http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/>`_
56+
57+
`Handling growth with Postgres <http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram>`_
58+
provides 5 specific tips from Instagram's engineering team on how to scale
59+
the design of your PostgreSQL database.
60+
61+
62+
------------------------------------
63+
Connecting to a database with Python
64+
------------------------------------
3665
To work with a relational database using Python, you need to use a code
3766
library. The most common libraries for relational databases are:
3867

@@ -47,6 +76,7 @@ is not necessary. Simply "import sqlite3" to begin interfacing with the
4776
single file-based database.
4877

4978

79+
-----------------------------
5080
Database third-party services
5181
-----------------------------
5282
Numerous companies run scalable database servers as a hosted service.
@@ -68,15 +98,10 @@ SQL integrates with Google App Engine but can be used independently as well.
6898

6999

70100
Database resources
71-
------------------
101+
==================
72102
`DB-Engines <http://db-engines.com/en/ranking>`_ ranks the most popular
73103
database management systems.
74104

75-
`PostgreSQL Weekly <http://postgresweekly.com/>`_ is a weekly newsletter of
76-
PostgreSQL content from around the web.
77-
78105
`DB Weekly <http://dbweekly.com/>`_ is a new (as of Feb 2014) weekly roundup
79106
of general database articles and resources.
80107

81-
`Total security in a PostgreSQL database <http://www.ibm.com/developerworks/library/os-postgresecurity/>`_.
82-
There is no such thing as total security but this is a good article anyway.

0 commit comments

Comments
 (0)