On switching away from Core Data
Brent Simmons ditched Core Data for raw SQLite on iPhone. His experience reveals why ORMs often become bottlenecks in scalable applications.
SFPUG: Operator Exclusion Constraints
Watch the San Francisco PostgreSQL User Group's December 2009 meeting on exclusion constraints and advanced PostgreSQL techniques.
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…