Event and reservation management platform
Event and reservation management platform independently developed to support real cycling events, participants and reservations.
Live website
CONTEXT
Rota Urbana organizes recurring group cycling events across the city. Previously, participant registrations were scattered across WhatsApp chats and manual spreadsheets, causing double-bookings, lost data, and event-day chaos.
PROBLEM / CHALLENGE
During ride opening announcements, hundreds of cyclists hit the website simultaneously from smartphones to claim limited bicycle slots. The application needed instantaneous validation, zero downtime, and a foolproof self-service lookup system.
MY ROLE
Architected and built the entire system independently: data model, booking engine, mobile-first participant flow, administrative check-in console, and high-concurrency production VPS hosting.
SOLUTION
Built a high-performance, mobile-first web application featuring instant booking verification, unique registration code generation, administrative check-in search, and automatic ride capacity enforcement.
KEY FEATURES
Fast reservation flow processing burst traffic without database locks or duplicate seat allocations.
Instant participant booking verification without requiring account creation or password friction.
Real-time check-in scanner and attendee lists tailored for event coordinators on mobile screens.
Automated status transitions (Open, Last Spots, Sold Out, Completed) driven by transactional counters.
TECHNICAL DECISIONS
Used ACID transactions in MySQL (`SELECT ... FOR UPDATE`) to eliminate race conditions when multiple riders reserve the final bike slot simultaneously.
Kept frontend bundle under 15KB of vanilla JavaScript and semantic CSS, guaranteeing instant rendering on low-tier smartphones and cellular networks.
Configured edge rules to serve static assets and cached read-only event schedules directly from the edge, reserving server resources strictly for dynamic booking transactions.
WHAT I LEARNED
Handling over 3,600 real reservations under real-world event pressure reinforced the value of data validation, predictable operational states, and bulletproof server stability.
Roadmap focuses on automated participant SMS/WhatsApp reminders and automated attendance reporting for municipal event partners.