SFPUG: Continuent Tungsten with PostgreSQL
Watch the San Francisco PostgreSQL User Group meeting from November 2009, featuring a talk on Tungsten cluster management.
Django, PostgreSQL, and Autocommit
Django's autocommit mode eliminates unnecessary transaction overhead for read-only views while enabling PostgreSQL's efficient INSERT...RETURNING syntax for…
Django, PostgreSQL, and Transaction Management
Django's automatic transaction wrapping works, but does it actually make sense for read-only operations?
ORMs and Their Discontents
ORMs make elegant code—until they don't. Watch how object-oriented patterns can quietly multiply your database calls, and learn when to break the rules.
Git vs Mercurial
Mercurial explains things patiently; Git sighs and rolls its eyes. Choose based on your project, not your preferences.
WordPress to Django+PostgreSQL, Part 4: Configuring Apache, Django, PostgreSQL
Set up Django, PostgreSQL, and Apache to serve your first web app. Step-by-step installation gets your Django project running on mod_wsgi.
WordPress to Django+PostgreSQL, Part 3: Installing Apache, Python 2.6, psycopg2, and mod_wsgi
Install Apache, Python 2.6, psycopg2, and mod_wsgi to get Django running on CentOS with PostgreSQL.
WordPress to Django+PostgreSQL: Part 2, Configuring PostgreSQL
Set up PostgreSQL on your VPS: create a postgres user, initialize a database cluster, enable PL/pgSQL and UUID functions, and configure automatic startup on…
The Mighty GUCS: A guide to the essential PostgreSQL settings you need to know
Watch the SFPUG October 2009 meeting video on GUCs (Grand Unified Configuration). Available for direct download or streaming on Vimeo.
WordPress to Django+PostgreSQL: Part 1, Installing PostgreSQL
Building PostgreSQL from source on CentOS 5.3: install dependencies, compile with OpenSSL and UUID support, and get ready to configure your database.