· 2 min · Django

Of Pickups and Tractor-Trailers

PostgreSQL on AWS can be great for many workloads, but high-volume data warehouses with extreme I/O demands hit a hard ceiling: EBS simply doesn't scale to the…

14 comments

· 1 min · IOS

Fixing the WWDC

Apple's ticket lottery is broken. The mad scramble to grab WWDC passes in minutes needs a better solution—whether that's a bigger venue, regional events, or…

0 comments

· 1 min · Language Issues

Two very cool things.

PHP's design flaws are legendary. See the photographic proof.

0 comments

· 1 min · Django

Blah, Blah, Blah, First Half of 2012 Edition

Find me at five conferences this spring and summer, from Ottawa to Florence and Portland.

1 comment

· 1 min · PostgreSQL

The Elements of postgresql.conf Style

PostgreSQL configuration files deserve better: stop mixing override styles, omit units, delete defaults, and leave junk files everywhere.

7 comments

· 1 min · Django

Instagram’s Technology Stack

Instagram's engineering team reveals the tech powering a billion-photo empire: PostgreSQL, Redis, and the surprising simplicity behind massive scale.

1 comment

· 4 min · Django

A Recipe for Django Transactions on PostgreSQL

Cut through Django transaction confusion with a practical recipe: use autocommit, skip transaction middleware, and wrap database-modifying code in a custom…

11 comments

· 1 min · PostgreSQL

PostgreSQL Performance When It’s Not Your Job

PostgreSQL performance doesn't have to be your specialty.

3 comments

· 1 min · PostgreSQL

“Sharding & IDs at Instagram”

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

1 comment

· 2 min · PostgreSQL

Cleaning up after your Bucardo goats

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

1 comment