Detailed notes for this lesson are being written. They appear here together with the video.
Video coming soonThis lesson’s video is being made
Start with the notes below; the video appears here as soon as it is on YouTube.
SQL and Databases · Lesson 89 of 90
Project 2: a concurrent ticket-booking system
OLTP design for seats and bookingsconstraints preventing double bookingtransactions with BEGIN IMMEDIATEoptimistic locking with version columnaudit triggerindexes for hot queriesload test with Python threads