Instagram's approach to distributing IDs across sharded PostgreSQL databases—and why getting this right matters for scaling.

Keep Bucardo's replication tables tidy with a pure-PostgreSQL purge function.

Download the slides from a 2011 OSCON tutorial on diagnosing and fixing broken Django applications.

My PGCon 2011 talk slides are now available for download, covering unconventional approaches to PostgreSQL data handling.

Two major tech conferences clash this year, and WWDC sold out in mere hours, leaving developers with an impossible choice.

Successful micro-businesses obsess over pleasing customers, not owner happiness. That's how they survive without venture capital or market dominance.

Advisory locks gain transaction-level support in PostgreSQL 9.1, unlocking new patterns for coordinating work without touching your schema.

Verifone attacks Square's card reader over unencrypted data—the same complaint they ignore for every other reader on the market. This is FUD, not security.

Learn Django with PostgreSQL in a full-day tutorial covering both general development and PG-specific techniques.

When Delicious died, Pinboard's tiny database nearly did too. A crash course in handling unexpected traffic spikes.