Glossary term
What is Transaction? Meaning for developers
In System Design
A group of changes that succeed or fail together. Example: BEGIN … COMMIT.
Learn it properly · System DesignLesson 21: ACID Transactions & Isolation LevelsTwo people book the last seat; a transfer crashes halfway. What ACID really promises, the write-ahead log behind durability, the five anomalies isolation levels do (and don't) prevent, and the practical fixes for real race conditions.In SQL & PostgreSQL
A group of statements that succeed or fail together.
Learn it properly · SQL & PostgreSQLLesson 6: Transactions, Isolation Levels and LocksAtomicity, read committed versus repeatable read versus serializable with two real sessions, row locks, SKIP LOCKED, deadlocks and retries.