Tweet I’ve spent a fair amount of time playing with SQLite in the past, and found that it is suprisingly nippy for a database that runs from a single file on your filesystem. I’ve used it succesfully both in it’s traditional form as an actual database, and in a somewhat non-traditional fashion as an in-memory database to make sure that [...]

Tweet I read a cool post the other day that explained how to speed up Mail.app, OS X’s built in mail client. The secret lies in the fact that Mail.app stores all of your mail in an SQLite3 database, and by running a vacuum command on the subjects table, it’ll speed up mail quite significantly. Never one to shy away [...]