Learning a few things about running SQLite

Running SQLite in production for a small Django site is fine, but the author learned that database operations are still complex. They discovered that running ANALYZE dramatically improved a full-text search query from 5 seconds to near-instant. They also encountered difficulties with cleaning up unwanted rows from the database.