SQLite in Production: Where It Shines
Write-ahead logging, backups, and the workloads where one file is enough.
👍 16
·
💬 7
5 posts —
Schemas, indexes, and queries that hold up under load.
Showing 5 posts
Write-ahead logging, backups, and the workloads where one file is enough.
How one product schema changed over four years, one diagram at a time.
How we dropped eleven indexes and made writes 30 percent faster.
A narrated walk through EXPLAIN ANALYZE output for a slow report query.
The expand-and-contract migration pattern with the exact SQL we ran.