undefined | Better HN

0 pointspixelesque2mo ago0 comments

No it doesn't - it allows a single writer and concurrent READs at the same time.

0 comments

3 comments · 1 top-level

InfraScaler2mo ago· 2 in thread

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.

yomismoaqui2mo ago

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

InfraScaler2mo ago

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

j / k navigate · click thread line to collapse