Database Challenges: Races, Locks and Transactions
Written by Zeeshan Adil
5 h 48 min · 4 parts · 33 chapters
From chapter 1, 5 h 48 min
By Zeeshan Adil. Break a small task queue on purpose, on real SQLite, PostgreSQL and MySQL databases. Step through two watchers claiming the same task, a crash that leaves half a change, four workers stuck behind one lock, and a watcher that dies holding its lock, then reproduce each failure in your own repository with real processes, fix it with the right database tool and prove the fix with a test and a chart from your own run. Learn each idea once, then see how each database does it and what it costs. Four challenges now, more coming. The repository needs a laptop with Node.js and Docker; on a phone, every Build chapter has a replay of a recorded run.
Read the course: the same chapters with diagrams, labs and quizzes.