Flamme Rouge Scoreboard
This web app is a personal side project built around Flamme Rouge, a cycling board my friends and I enjoy playing. The app acts as a scoreboard for multi-stage races, storing results and standings across sessions. I built it to practice end-to-end development: from designing the database and backend logic to building the frontend and deploying the finished product.
Overview
After having played the original game a couple of nights with my friends, we felt the game was missing the opportunity to race across multiple stages, like they do in Tour de France. So we created rules for a Grand Tour concept, with sprint and mountain points, time trials and much more. However, it was hard to keep track of all this in an Excel spreadsheet and I wanted to get some experience with web developing, so I decided to create this web-app. The app lets users create races, record stage results, and automatically compute classement, sprint, and mountain standings. Results are stored across 8 related tables in a PostgreSQL database hosted on Azure, which I set up and manage myself, so players can continue their race over multiple sessions.
Try the app: Launch the Flamme Rouge Scoreboard on Azure.
Tech & Tools
- Backend: Flask (Python), session management, Jinja2 templates
- Database: PostgreSQL hosted on Azure for secure race/team data storage
- Frontend: HTML/CSS, JavaScript for dynamic forms (e.g. entering results)
- Deployment: Azure App Service
Key Features
- Multi-stage race creation and result tracking
- Automatic classement, sprint, and mountain classification scoring
- Optional advanced rules: point systems, assistant riders, time trials, “good day/bad day” modifiers
- Stage continuation via unique Race ID stored across sessions