WordPress to Django+PostgreSQL: Introduction
Migrating a WordPress blog to Django and PostgreSQL on a bare VPS.
Getting PostgreSQL 8.4 to only listen on Unix sockets
PostgreSQL's `listen_addresses` parameter has a secret empty-string setting that disables TCP/IP entirely, leaving only Unix sockets active.
Only NATURAL: JOIN clauses vs WHERE conditions
NATURAL JOIN shortcuts can silently break when you add columns with matching names. Learn why explicit ON and USING clauses are safer and often more readable.
SFPUG: Statistics and Postgres – How the Planner Sees Your Data
Watch the September 8, 2009 SFPUG meeting video on PostgreSQL statistics and optimization techniques.
Quote of the Day
When an application's lock strategy feels more broken than cautious, it's time to rethink your approach to concurrency.
Quote of the Day
Hovercrafts sound fun until you realize they have no brakes, slide sideways in the wind, and the authorities banned them from roads for good reason.
SFPUG: Windowing and Common Table Expressions
Watch the August 2009 San Francisco PostgreSQL User Group meeting. Video available for streaming or download.
Quote of the Day
Dijkstra's famous quip reminds us that asking "can machines think" is as misguided as asking "can submarines swim"—the real questions are about capability and…
Resume Building
A Tron sequel teases the ultimate programmer showdown, but the original film makes one villain suspiciously hireable.
Dot Dot Dot
Joe Conway argues against Objective-C's dot notation for method calls, claiming it blurs the line between field access and code invocation.