Viatour
About the Project
An interactive, full-stack travel booking application that allows users to discover, compare, and book tailored tour packages worldwide. The system features a responsive search engine with date and destination filters, a secure payment gateway integration, and a dedicated admin console to track reservations and customer reviews.
The Challenge
Handling high-concurrency booking requests during holiday seasons without double-booking rooms or tour guides. Heavy read-write transactions on tour slots led to database locks and slow response times.
The Solution
I designed a slot reservation system using transaction blocks in PostgreSQL with database-level row locks. I offloaded temporary seat reservations to an in-memory database with automatic TTL (time-to-live) expiration, ensuring slots were held for only 10 minutes during checkout.
Technologies Used
