What is write skew? Why does snapshot isolation allow it and how does SERIALIZABLE stop it?

Answer preview

Write skew happens when two transactions read an overlapping set of rows, each makes a decision based on that read, and each then writes to a different row — so no write conflict is detected, yet together they violate an invariant that neither would have broken alone.…