transactions

How MVCC Works: Snapshots, Version Chains, and Why Readers Don't Block Writers

A long-running report wants a consistent view of every row it started reading. A checkout wants to update one of those rows at the same mome...

Sarthak Bystander 16 Sept, 2026

How Two-Phase Commit Works: Prepare, Decision, and Why Blocking Happens

A payment service writes a debit. An inventory service reserves a unit. Either both must become durable facts, or neither may. That is an at...

Sarthak Bystander 15 Sept, 2026