In PostgreSQL, REPEATABLE READ works this way. Reads never block and never see later commits, but write skew is still possible.
Snapshot isolation
Each transaction reads from a consistent snapshot of the data taken when it started.
In PostgreSQL, REPEATABLE READ works this way. Reads never block and never see later commits, but write skew is still possible.