SQLITE

Julia Evans shares hard-won production lessons from running SQLite at scale - from the ANALYZE command that cut query times 100x to backup strategies and write contention gotchas.

SQLite's flexible typing lets you store anything anywhere. STRICT mode fixes that - here's why you should enable it for every new table.