Hi,
Is that last quote just imprecise writing or is there really a
difference between SQLite's Snapshot Isolation in WAL mode and
its Serializable isolation in ROLLBACK mode?
Yes, there is a difference.
...sorry, it seems it was my turn to do some sloppy writing!
Thanks for the detailed
Serialization isolation requires 'The databases ends up in the state it
would appear if every transaction were run sequentially'. It doesn't
actually require that all transactions occur sequentially, just that the
database ends up in a state as though they had.
Why do you think that SQLite's
On Tuesday, 9 July, 2019 20:34, Andy Bennett wrote:
>However, the wording for WAL mode is confusing me.
>isolation.html says 'all transactions in SQLite show "serializable"
>isolation.' but it also says 'In WAL mode, SQLite exhibits "snapshot
>isolation"'.
>Snapshot Isolation and Serializable
Hi,
I'm reading the docs:
https://sqlite.org/isolation.html
...and I need some clarification!
It is easy to see that ROLLBACK mode is SERIALIZABLE because all concurrent
readers have to leave before a PENDING lock is upgraded to an EXCLUSIVE
lock.
However, the wording for WAL mode is
4 matches
Mail list logo