Things that surprised me while running SQLite in production
One thing missing from this:<p>There are massive performance gains to be had by using transactions.  In <i>other</i> RDBMSs transactions are about atomicity/consistency.  But in SQLite, transactions are about batching inserts for awesome speed gains.  Use them!