News for hackers. Stuff that matters.
Re:LiteFS a FUSE-based file system for replicating SQLite by spiffytech on Wednesday July 27, 2022 @08:21AM (#32249576)
This is saying that SQLite allows reads and writes to happen simultaneously, but it's still single-writer. There's a WIP branch to add concurrent writes.

> Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.

https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi...

There are no comments on this comment yet.