From the always excellent xkcd, this comic  Oct 10 2007

From the always excellent xkcd, this comic absolutely drips hilarious nerdiness and nerdy hilariousness all over the place. "Oh yes, Little Bobby Tables, we call him."

For my own future reference: an explanation  Oct 03 2007

For my own future reference: an explanation of SQL joins using Venn diagrams.

Update: Another crack at the Venn diagram thing.

Part 2 of an ongoing series about how  Apr 27 2006

Part 2 of an ongoing series about how databases are used in Web 2.0 apps. Both Bloglines and Memeorandum don't bother with databases, opting for flat files instead.

Update: Here's how Flickr does it. See also normalization is for sissies.

Code snippets for working with tags and SQL  Apr 08 2005

Code snippets for working with tags and SQL.