Building a Real-Time Volunteer Sync Engine with Flask-SocketIO and MySQL

As a first-year CS student, I’ve noticed a recurring theme in many management systems: they feel static. Most volunteer portals require manual refreshes or heavy API polling. During a live event, that "lag" can lead to confusion. I wanted to build an architecture that feels live. The Core Concept The goal was simple: Admins scan a physical QR ID of a volunteer, and their status (Free/Busy/Assigned) changes instantly across every connected dashboard in the organization—without a single page refresh. The Tech Stack To keep the system lightweight but powerful, I chose: Backend: Python & Flask Real-Time Layer: Flask-SocketIO (WebSockets) Database: MySQL with custom connection pooling Auth: Werkzeug (Hashing & single-session enforcement) UI/UX: Vanilla JS & CSS (Completed with the help of AI models) Technical Highlights Real-Time State Synchronization Instead of the frontend "asking" the server for updates (polling), the server "pushes" updates the moment a database change occurs. Using Fla