SQL

We're big fans of the relational model. We'll probably tell you things about your database you never knew, and make it scale higher and run faster than you ever thought possible.

We've done some presentations about databases:

  • Postgres FTW. We've considerable experience with MySQL, Oracle and Postgres. This presentation is about why Postgres is usually the best choice.
  • Postgres Rules. Not as in "yeah, baby, Postgres rules!" (although it does), but in the sense of "Postgres has an amazing feature called Rules that most people don't understand."
  • MySQL, Postgres, and Rails. A feature comparison of Postgres and MySQL. A little old now, but still basically right.
  • Indexes: The Second Pillar of Database Wisdom. Most developers don't really understand how to get the most out of database indexes.