[shalabhc]

For all interested in this topic, I highly recommend the book Designing Data Intensive Applications https://www.goodreads.com/book/show/23463279-designing-data-....

It goes into not only different isolation levels, but also some ambiguity in the traditional ACID definition.

I believe a 2nd edition is imminent.

[vismit2000]

Second edition is available now: https://www.oreilly.com/library/view/designing-data-intensiv...