Choosing between hstore and JSON in PostgreSQL?

PostgreSQL advisory locks let you coordinate complex jobs without database tables.

PostgreSQL as a schemaless database: exploring how the world's most advanced open source database can compete with NoSQL systems.

Catch errors mid-loop and roll back your database work without propagating the exception.

DjangoCon US 2013 is now accepting talk proposals. Submit your ideas before the deadline closes.

Psycopg2 2.5 lands with native JSON and range type support, making it easier than ever to work with PostgreSQL's modern data types from Python.

PostgreSQL lets you name a table after built-in types like text, but it confuses the type system and can break pg_restore. Just don't.

Bridge PostgreSQL and Python with practical techniques shown at PyPgDay 2013.

Lose a single tablespace in PostgreSQL and you've lost your entire database. Tablespaces aren't optional storage—they're critical infrastructure.

A forgotten pg_hba.conf update broke streaming replication for weeks—but WAL archiving kept the standby current anyway. Here's why you need both.