TechJulia Evansabout 23 hours ago
Learning a few things about running SQLite
5 min read
A developer running SQLite with Django found a full-text search query on 4000 rows took 5 seconds. Running ANALYZE immediately cut the time to about 0.05 seconds. The project uses restic and Litestream for backups to AWS, with cleanup done in small batches to avoid timeouts.
Level
Hype check
Tap to vote and see what everyone thinks.
Summary by ByteBrief
