Improve SQLite Performance With Writeahead Logging

With SQLite version 3.7.0, one can configure a database to use writeahead logging instead of traditional rollback logging. This enables much better write performance without affecting read performance noticeably. This video uses Ruby, the SQLite “Amalgalite” gem, and SQLite 3.7.0 to show how this works.

For more details check out http://www.squidoo.com/sqlitehammer and http://www.squidoo.com/sqliteprogramming.