homeaboutarchivenewslettermembership!
aboutarchivemembership!
aboutarchivemembers!

kottke.org posts about sql

From the always excellent xkcd, this comic

posted by Jason Kottke   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

posted by Jason Kottke   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

posted by Jason Kottke   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

posted by Jason Kottke   Apr 08, 2005

Code snippets for working with tags and SQL.