News for hackers. Stuff that matters.
Re:Consider SQLite by umvi on Wednesday December 29, 2021 @02:08PM (#29728635)
> Only a single process can write to the database at any time; it does not support concurrent writers.

I think you can do concurrent writing now with Write-Ahead Logging (WAL): https://www.sqlite.org/wal.html

I've never tried it though, so I don't know how suitable it is for web apps that might potentially have multiple processes trying to write to the DB at the same time.

Re:Consider SQLite by teraflop on Wednesday December 29, 2021 @02:16PM (#29728770)
Nope. In the default rollback-journal mode, SQLite supports either multiple readers or a single writer at a time. WAL mode improves this to multiple readers and at most one writer.

But transactions in SQLite are often fast enough that this could still be acceptable for a lot of purposes, especially on an SSD.

Re:Consider SQLite by srcreigh on Wednesday December 29, 2021 @02:14PM (#29728733)
There is no concurrent writing with WAL mode