Transaction-Level Advisory Locks in PostgreSQL 9.1
Advisory locks gain transaction-level support in PostgreSQL 9.1, unlocking new patterns for coordinating work without touching your schema.
Concern Troll is Concerned: Verifone vs Square
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.
Django and PostgreSQL at PostgreSQL Conference East
Learn Django with PostgreSQL in a full-day tutorial covering both general development and PG-specific techniques.
“Anatomy of a Crushing”
When Delicious died, Pinboard's tiny database nearly did too. A crash course in handling unexpected traffic spikes.
“10 Ways to Kill Performance”
Learn ten surprisingly common mistakes that tank PostgreSQL performance, from a talk at PgDay SCALE 9X.
“10 Easy Ways to Destroy Performance” at pgDay at SCALE-9X
Ten innocent-looking mistakes that silently tank your PostgreSQL performance—and how to spot them before they wreck your database.
“Django Development with PostgreSQL” at PostgreSQL Conference East
Join a full-day deep dive into Django and PostgreSQL at PostgreSQL Conference East in New York, March 22–25.
PostgreSQL for Servoy Developers
PostgreSQL for Servoy Developers: slides from ServoyWorld 2011 now available online.
Nobody Here But Us Chickens: Google and Lies We Tell Ourselves
Architectural decisions aren't always what they seem. Learn why calling a tradeoff a feature is a lie you tell yourself—and why honesty matters more.
Extra columns when doing .distinct() in a Django QuerySet
Model ordering can silently break `.distinct()` queries by including hidden fields in the SELECT clause.