One ANALYZE command resulted in a 100x query speedup for one person. There was no need to restart the server, reconfigure the network, or receive an alert at 3am. That's the Julia Evans post about running SQLite in production that linked in my brain with a chat I had with Richard Schneeman five...
Source: [Dev.to](https://dev.to/adioof/sqlite-runs-more-production-than-the-modern-data-stack-wants-you-to-believe-37f8)