The "SQLite is single-writer" myth, and what WAL actually does
WAL changed the rules. Most of the things people repeat about SQLite concurrency are about a SQLite that hasn't existed for a decade.
This post is being moved off the static site.
The full text is currently on the
feed as a long-form note.
I'm in the slow process of breaking the longer posts back out into
permalinks, and this one isn't done yet. Email me if you
want the original — I have it.
Why is this here at all? Because old links shouldn't break, and I'd rather give you a placeholder with a way forward than a 404.