PRAECIPUA
sol@praecipua.net (618) 720-0128

FrontRow

Enterprise Facilities Management & Custom Software Development for the Global Costuming Community

FrontRow System Banner

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

PR

Convention Lifecycle

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.
PR

Contestant Management

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.
PR

Stage Performance Tracking

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.
PR

Awards & Judging

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.
PR

Multilingual Interface

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.
OS

Modern Architecture

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.