Field notes on operating SQLite in production

Sources: Julia Evans, HN discussion
Summary: Julia Evans published field notes on 2026-07-17 from running SQLite for a small production service, covering backup strategy, credential handling for offsite copies, and reading query plans to understand index use. The post is a practitioner walkthrough rather than a benchmark.
Comments: Commenters pointed to SQLite's .expert mode for index recommendations and to the sqlite_stat1 statistics the planner uses for selectivity estimates.
Why it matters: SQLite is increasingly used as an application database, so concrete operational notes on backups and query planning address a common gap.