News for hackers. Stuff that matters.
Re:SQLite Transactions by tnodir on Friday July 19, 2024 @04:17AM (#41003358)
https://www.sqlite.org/isolation.html

"In WAL mode, SQLite exhibits "snapshot isolation".

When a read transaction starts, that reader continues to see an unchanging "snapshot" of the database file as it existed at the moment in time when the read transaction started.

Any write transactions that commit while the read transaction is active are still invisible to the read transaction, ..."

Re:SQLite Transactions by bvrmn on Monday July 22, 2024 @04:57AM (#41032196)
Yes, snapshot isolation is a way to implement READ COMMITTED level.