Post #2364459
2026-05-10 19:03 UTC
I think you got the wrong caption. It’s the world if SQLite supported multiple concurent writes.
Stupid transaction deadlocks…
Replies (2)
-
@irelephant@lemmy.dbzer0.com 2026-05-10 19:58
In my case, I want to use sqlite locally, for development, but I don’t want to add a load of jank to handle booleans for sqlite.
-
@dan@upvote.au 2026-05-11 02:02
WAL mode makes writes a lot faster, which is sufficient for a bunch of use cases. Writers do still need to wait, but they have to wait for a shorter duration. It’s still not the right choice for write-heavy use cases, of course.