SQLite WAL Mode: What Actually Changes When You Switch from the Rollback Journal
SQLite's default rollback journal blocks readers during writes. WAL mode lets readers proceed concurrently with a single writer. Here's how to enable it, what changes, and when to avoid it.