Lessons Learned: Running SQLite in Production with Django

Learning a few things about running SQLite

I recently used SQLite for a Django site and discovered that even small databases require careful management. I learned that running ANALYZE is crucial for query performance, while cleanup operations can cause timeouts and crashes. I also explored backup strategies using restic and litestream, and considered splitting tables across multiple database files. Despite its simplicity, SQLite demands respect as a real database.

"SQLite is still a database, databases are complicated, and I do not know a lot about operating databases."