18:52
“Anatomy of a Crushing”
A fun and interesting article about a sudden burst in traffic at Pinboard when Yahoo! announced they were shutting down Delicious. Relevant to app and DB designers everywhere.
8 March 2011
25 February 2011
17:17
“10 Ways to Kill Performance”
The slides from my talk, “10 Easy Ways to Destroy Performance” from PgDay at SCALE 9X are available.
15 February 2011
22:22
“10 Easy Ways to Destroy Performance” at pgDay at SCALE-9X
I’ll be presenting a talk on “10 Easy Ways to Destroy Performance” at pgDay at SCALE-9X, on February 25th in Los Angeles.
22:19
“Django Development with PostgreSQL” at PostgreSQL Conference East
I’ll be presenting a full-day tutorial on Django Development with PostgreSQL at PostgreSQL Conference East, March 22-25 in New York!
4 February 2011
01:59
PostgreSQL for Servoy Developers
The slides from my presentation on PostgreSQL for Servoy Developers, presented at ServoyWorld 2011, are available here.
31 December 2010
13:50
Nobody Here But Us Chickens: Google and Lies We Tell Ourselves
tl;dr: If you make a tradeoff, be honest about it. Don’t lie to yourself that you are making a positive architectural decision when you make a negative tradeoff.
22 December 2010
15:54
Extra columns when doing .distinct() in a Django QuerySet
tl;dr: If you are doing a .distinct() query and limiting the results using .values() or .values_list(), you may be in for a surprise if your model has a default ordering using the Meta value ordering. You probably want to clear the ordering using .order_by() with no parameters.
00:00
Getting the ID of Related Objects in Django
tl;dr: Don’t retrieve a whole row just to get the primary key you had anyway. Don’t iterate in the app; let the database server do the iteration for you.
17 December 2010
11:35
Why I run qmail
There’s a very nasty root exim exploit in the wild.
Updated: To be fair to the hard-working exim team, this bug was fixed some time ago.
09:48
Comparing NULLs Considered Silly
tl;dr: You can’t compare NULLs. A nullable primary key is a contradiction in terms. You can’t join on NULL, so a NULL foreign key refers to nothing, by definition. NULL doesn’t do what you think it does, no matter what you think it does.