6 ms·

Maybe I'm misinterpreting your comment but SQLite operates with serializable isolation[1] so I don't think write skew is possible. For both the rollback journal

Maybe I'm misinterpreting your comment but SQLite operates with serializable isolation[1] so I don't think write skew is possible. For both the rollback journal and the WAL, SQLite only allows a single write transaction at a time so you can't have two transactions updating with different snapshots. Also, from that Wikipedia article: > Were the system serializable, such an anomaly would be impossible [1] https://www.sqlite.org/isolation.html https://www.sqlite.org/isolation.html

ghusbands 4y ago
For someone reading the article fresh, without other articles or outside knowledge, the quoted text pretty much states that snapshot isolation is sufficient for isolation in general, and it's a common enough incorrect belief that it's worth pointing out as untrue. I'm glad to hear that SQLite has chosen serializable isolation as the one true way, even with the newer BEGIN CONCURRENT functionality.