CineSpot
3D cinema ticket booking & atomic concurrency system
An interactive 3D cinema booking platform with realistic auditorium sightline simulation and zero-double-booking guarantees using PostgreSQL pessimistic row locking.
Problem
High-traffic cinema ticket bookings frequently suffer from race conditions, double-booked seats, and poor seat perspective previews before purchasing.
Approach
Engineered an atomic reservation engine backed by PostgreSQL row-level locks (SELECT ... FOR UPDATE) and dead-lock prevention sorting, paired with a custom Three.js 3D auditorium simulator with exact eye-level seat sightline inspection.
What shipped
- Zero double-booking guarantee validated through 18 automated concurrent stress tests.
- Interactive 3D auditorium with 80 physical seats, stadium risers, and dynamic live video projection.
- 5-minute atomic seat hold with resilient payment retries and automatic cron-based expiration release.
Stack
React
TypeScript
Three.js
Node.js
Postgres
Docker