tl;dr: A developer running a Django site on SQLite shares lessons learned: running ANALYZE dramatically sped up a slow FTS5 query (from 5s to 0.05s) by giving the query planner better statistics. They also hit issues with SQLite's single-writer limitation during bulk deletes causing worker timeouts and crashes, which they work around with small batches. For backups, they've used both restic (with VACUUM INTO) and Litestream for incremental replication to S3.