Index

Module 01 · Data SystemsData on one machine

Transactions

Transactions
Transactions · Open board

Data Systems track.

This lesson is about what happens when two things touch the same row, or the same rule, at once, and why the fix that catches all of it is expensive on purpose.

Before you start. The previous lesson, Encoding and Schema Change, turned a record into bytes in an agreed format, so two programs changing independently could still read each other’s data. Here everything stays on one machine; you only need to read a row of a table and picture two people reading the same one at once.

Continue reading with a plan

The first three lessons of every track are free. This lesson is included with a plan, which unlocks every lesson, board, video, lab and paper for one price.

View plans →Already a member? Sign in

Lab

Two doctors each check that someone else is on call, both go off call, and both commit. Which level notices?

Pick You see the database as it was when you began, press Play next operation to the end, and watch races permitted.

Open Isolation levels →

Related paper

Review Data Systems →

Saved in this browser, and to your account when you sign in.