PHATPHUM.ME
Personal2025

HRCL 2025 Seminar Booking

Real-time Seminar Registration & Seat Reservation System

HRCL 2025 Seminar Booking

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

Gallery image 1

Real-time Seat Map and Reservation Status

Gallery image 2
Gallery image 3
Gallery image 4
Gallery image 5
Gallery image 6
Gallery image 7
Gallery image 8
Gallery image 9