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