Databases

NewSQLite: Understanding and preventing “database is locked”

Why SQLite responds with SQLITE_BUSY and “database is locked,” how WAL mode, busy_timeout, short transactions, and retries avoid locks, and why slow storage and I/O load on a NAS trigger the issue in the first place. Includes a real-world Grafana case.