Product Introduction
FrontRow Masquerade System
The FrontRow system is a bespoke, full-stack web application built with Python/Flask and PostgreSQL to streamline the complex lifecycle of masquerade and stage performance events.
Built for efficiency, data integrity, and user experience, it provides administrators, judges, and contestants a unified platform to manage conventions, track costume entries, and assign technical requirements for live performances.
System Capabilities
Manage the full span of an event, from initial creation to final results. Define venues, rules URLs, and set active dates.
- Multi-Event Support: Archive past conventions and highlight current ones dynamically.
- Venue & Rules: Attach venue names and external rule documentation automatically.
Track participants across different skill levels: Novice, Journeyman, Master, and Youth.
- Photo Uploads: Securely store costume photos with file validation (PNG/JPG/GIF).
- Contact & Metadata: Maintain addresses, emails, and external IDs for payouts or contracts.
Capture the technical details required for live stage execution.
- Audio/Visual Notes: Record lighting cues, music requirements, and dark-stage protocols.
- Category Organization: Sort entries by Sci-Fi, Fantasy, Anime, or Gaming sub-genres.
Structure competition results with flexible award categories (Workmanship, Presentation, Special).
- Dynamic Selection: Link awards to winning presentations and track sub-types.
- Judging Workflow: Streamline the process of assigning prizes post-judging.
Designed with Flask-Babel to support multiple languages out of the box.
- Dynamic Language Switch: Toggle between English, Spanish, and French via session state.
- Localized Date/Time Formatting: Consistent display across timezones using Flask-Babel utilities.
Built on a robust, modern stack that prioritizes data integrity and scalability.
- Database: PostgreSQL 14 with UUID support for secure entry tracking.
- Framework: Python 3.11+ using Flask 3.1.2 and SQLAlchemy ORM.