Day 11 of 14 35 minACIDIsolationMVCC
All-or-nothing changes, even with many users at once. Learn what ACID means, group statements into transactions, recover with savepoints, and see how PostgreSQL keeps concurrent users from tripping over each other.
By the end of today you can
- Explain the four ACID guarantees
- Group several statements into one atomic transaction
- Recognise an aborted transaction and recover with ROLLBACK or a savepoint
- Describe how MVCC lets readers and writers work at the same time
- Choose an isolation level and lock rows with SELECT … FOR UPDATE
What's inside
- 7 sections
- 4 diagrams and mind maps
- 5 code examples you can run
- 4-question quiz
- 1ACID in one picture
- 2A money transfer
- 3When something fails
- 4Savepoints: undo part of a transaction
- 5Many users at once: MVCC
- 6Locking a row you're about to change
- 7Isolation levels
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free