Personal2025
HRCL 2025 Seminar Booking
Real-time Seminar Registration & Seat Reservation System

Role
Full Stack Developer
Year
2025
Team
Solo Project
Tech Stack
Next.js, MySQL, Prisma, Pusher
A real-time web application for seminar registration and seat reservation, featuring an organizer (admin) interface to monitor the live seat map, identify who occupies each seat, and manage the attendee list instantly. The system was deployed and used in a real event for the Faculty of Hospitality Industry, Hotel & Restaurant major, Kasetsart University (Kamphaeng Saen Campus) on Wednesday, October 1, 2025 (08:00–12:00). It served 190 registrants and 3 admins smoothly; minor initial issues were resolved promptly.
01 The Problem
- Organizers struggled to plan accurately due to unclear seat capacity and unreliable registration tracking, creating operational risk on event day.
- Real-time confirmation was essential to ensure attendees felt confident their registration and seat were successfully secured.
- Organizers needed structured attendee data (e.g., student IDs) for downstream record-keeping, but the previous process was difficult to validate and update in time.
02 The Solution
- Implemented real-time seat status synchronization using Pusher (WebSockets) so registrants and organizers always see the same up-to-date availability.
- Once a user confirms a reservation, the system persists the record and immediately updates the seat to “reserved,” minimizing confusion and preventing double-booking under high concurrency.
- Built an admin-facing dashboard to view the seat map in real time, identify who is seated where, and access a consolidated attendee list for operational management and post-event processing.
03 The Result
- Attendees received immediate, clear seat confirmation, reducing uncertainty and improving confidence in the registration process.
- Organizers gained real-time visibility into occupancy and attendees, enabling smoother on-site operations and better coordination.
- Handled high-concurrency registration reliably in production usage with 190 registrants and 3 admins.
Project Gallery

Real-time Seat Map and Reservation Status







