News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by rsalus on Friday May 29, 2026 @08:22PM (#48331050)
there is a difference between concurrency in a distributed environment and concurrency on a single machine across processes. SQLite is incredibly useful for the latter.

you seem like the inexperienced one to me..

Re:SQLite is all you need for durable workflows by zaptheimpaler on Saturday May 30, 2026 @12:13AM (#48332498)
SQLite does not support concurrent writes at all (on a single machine), a single writer process locks the entire database.
Re:SQLite is all you need for durable workflows by andersmurphy on Saturday May 30, 2026 @03:11PM (#48339663)
It doesn't block reads. Single writer systems are often faster than concurrent writers no coordination overhead and you can batch.
Re:SQLite is all you need for durable workflows by rsalus on Sunday May 31, 2026 @12:05AM (#48342943)
not really true, SQLite supports WAL mode which allows concurrent writes (technically write _attempts_, but these writes are exceptionally fast and are serialized to the file-system anyway, so functionally equivalent to concurrent writes for p50 use case).

also, use-case for massively concurrent writes is pretty narrow, and SQLite is not optimizing for that anyway.

Re:SQLite is all you need for durable workflows by slashdave on Saturday May 30, 2026 @01:57AM (#48333077)
> you seem like the inexperienced one to me

There is irony here