Computers are infuriating. At PyCon 2023 I talked about consistency and isolation in databases, and showed Python implementations of four isolation levels. Here’s the PyCon video and here’s a Talk Python podcast interview with Michael Kennedy (episode page). The subject goes a bit deeper than I could cover in 30 minutes; here are links for further reading. First, orient yourself with Kyle “Aphyr” Kingsbury’s map. Isolation Basics Granularity of Locks in a Shared Data Base, Gray et. ...
