Posts tagged “sqlite”
2 posts Subscribe by RSS
2 posts
SQLite BEGIN DEFERRED, IMMEDIATE, and EXCLUSIVE: Handling SQLITE_BUSY Mid-Transaction
Why a mid-transaction write in SQLite can fail with SQLITE_BUSY despite busy_timeout, how BEGIN IMMEDIATE moves contention to the start, and what to retry at each failure point.
Why your SQLite -wal file keeps growing: checkpoints and read transactions that never end
Why an SQLite -wal file keeps growing: the 1000-page auto-checkpoint, open read transactions that stall checkpoints, PASSIVE/FULL/RESTART/TRUNCATE, and journal_size_limit, per the official docs.
No posts match. Try another word.