Optimizing SQLite for servers

Optimizing SQLite for servers

Sylvain Kerkour's comprehensive set of lessons learned running SQLite for server-based applications.

There's a lot of useful stuff in here, including detailed coverage of the different recommended PRAGMA settings.

There was also a tip I haven't seen before about "BEGIN IMMEDIATE" transactions:

"By default, SQLite starts transactions in DEFERRED mode: they are considered read only. They are upgraded to a write transaction that requires a database lock in-flight, when query containing a write/update/delete statement is issued. …

applications coverage databases lessons learned performance running server servers set sql sqlite transactions