Hacker News new | ask | show | jobs
by pixelesque 64 days ago
No it doesn't - it allows a single writer and concurrent READs at the same time.
1 comments

Thanks! even I run a sqlite in "production" (is it production if you have no visitors?) and WAL mode is enabled, but I had to work around concurrent writes, so I was really confused. I may have misunderstood the comments.
Writes are super fast in SQLite even if they are not concurrent.

If you were seeing errors due to concurrent writes you must adjust BUSY_TIMEOUT

Thanks I'll have a look. For now I just had a sane retry strategy. Not that I have any traffic, mind you :-)))