Isolation Levels

The previous chapter introduced isolation as the guarantee that concurrent transactions don't interfere with each other. But isolation isn't binary.

The SQL standard defines four isolation levels, each offering a different trade-off between data correctness and concurrency performance. Stronger isolation means fewer surprises, but more contention between transactions.