←Return to Works

Celeritas - Sports Event Web Manager

A comprehensive web management system for school sports events, solving operational challenges for both student organizers and participants. Features real-time score updates, schedule management, and tournament brackets with Firebase Realtime Database integration.

~150
Concurrent Connections
Peak concurrent users during school event
100%
Production Success
Zero incidents during live operation
Very High
User Satisfaction
Overwhelming support from staff, students, and teachers
Significant
Workload Reduction
Eliminated manual tasks and late-night work for organizers
Celeritas - Sports Event Web Manager screenshot 1
Celeritas - Sports Event Web Manager screenshot 2
Celeritas - Sports Event Web Manager screenshot 3
Celeritas - Sports Event Web Manager screenshot 4

System Architecture

Architecture Diagram 1

Static site hosting on any platform with Firebase Realtime Database for data synchronization. Conflict resolution via version control system (_version field). ExcelJS for official record exports.

Technologies Used

  • React v18
  • TypeScript
  • MUI Material
  • Firebase Realtime Database
  • Firebase Authentication
  • g-loot/react-tournament-brackets
  • i18n (国際化対応)
  • ExcelJS
  • SSG (Static Site Generation)

Features

Real-time Score Management
  • Live score updates across all devices
  • Tournament bracket visualization
  • Automatic playoff progression tracking
  • Conflict resolution with version control system
  • Instant synchronization via Firebase Realtime Database
Event & Schedule Management
  • Create and manage multiple sports events
  • Automated schedule generation
  • Competition creation and team assignment
  • Real-time schedule updates for all participants
  • Delay notifications and status updates
Admin Operations
  • Centralized admin dashboard
  • Complete event lifecycle management
  • Score entry and correction
  • Excel export for official records
  • Built-in operation help guide
  • Firebase Authentication for secure access
Student Experience
  • View-only access for all students
  • No need to visit match locations in hot weather
  • Real-time match status and location
  • Easy-to-read schedules and progression
  • Playoff qualification tracking
Security Design
  • Two-tier authorization: Admin staff & General students
  • No personal information stored (school policy compliance)
  • Firebase Authentication system
  • Simple permission structure for easy handover
  • Safe for student-led operations
github
github