Skip to content

Database locking is a safety feature

you have to be sure that when you put when you when you do a transaction to a database, you have to be sure that the data is not going to change in the middle of, of the change you're trying to make.

Episode 121: Lawful but Awful (episode page, opens in a new tab) February 10, 2023, 2:45 p.m. CT 01:12:08 (play audio from this timestamp, opens in a new tab)

Voice-matched

Summary

Asked for a primer on table locking, Dave explains atomic operations. A transaction must be sure the data won't change in the middle of the change; otherwise parallel updates and deletes corrupt the data. The query plan locks the rows that could conflict, and that locking is critical to safety.

Also said

Episode 121: Lawful but Awful (episode page, opens in a new tab) February 10, 2023 01:13:27 (play audio from this timestamp, opens in a new tab)
Locking is, is critical to safety.
Voice-matched