Join a full-day deep dive into Django and PostgreSQL at PostgreSQL Conference East in New York, March 22–25.

PostgreSQL for Servoy Developers: slides from ServoyWorld 2011 now available online.

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.

Model ordering can silently break `.distinct()` queries by including hidden fields in the SELECT clause.

Stop fetching entire rows to grab a foreign key you already have, and let the database handle iteration instead of your app.

A critical root exploit in Exim is spreading—but the developers patched it months ago. Keep your mail server updated.

NULL doesn't behave like you think it does. Nullable primary keys are meaningless, NULL values can't be joined, and NULL = NULL returns NULL—not true.

Use psycopg2's server-side cursors in Django to stream enormous result sets without loading them into memory.

Django's QuerySet caching and default fetch behavior can silently consume gigabytes of memory on large result sets.

Stop writing result[4]—psycopg2.3 beta now lets you fetch query results as named tuples with intuitive dot notation.