Event Scoring
Why do ballerinas always stand in their toes? Why don't they get taller dancers?

Link
Description
This backend event scoring system was designed for robust and consistent performance in live, in-person settings. Since its initial deployment, it has demonstrated a strong track record of reliability at various events, including the BCC Choir Contest and the HRAB (Hotel and Restaurant Association of Baguio) beauty pageant. To maintain its efficiency and reliability, the system has undergone rigorous load testing and performance optimization. Additionally, security measures have been implemented to protect data and prevent unauthorized access.
Functions
CRUD
A simple secure CRUD backend, with extra considerations for performance and stability.
Work Done
Interview
Collaborated with the pageant organizers to gather requirements and ensure system met business needs.
Development
Designed database schema and created entity-relationship charts to ensure efficient data storage and relationships.
Developed backend code.
Conducted rigorous endpoint and usability testing to ensure data reliability and integrity, including:
data validation and error handling
data security and access control
data backup and recovery procedures
Live simulations prior to events.
Created database, tables, views, and stored procedures.
Produced comprehensive API documentation to facilitate future development and integration.
Deployment
Configured settings for DNS, hosting, and primary server, and deployed test and production environments of the system.
Shutdown server after the event has concluded.
Support
Provided training and support to operators to ensure successful adoption and usage of the system.
Mission Control
Monitor server health during events to ensure the integrity of data.
Maintenance
Addressed bugs and rolled out updates and feature requests to enhance functionality and performance.
Tech Stack
mocha + supertest + chai - endpoint testing
grafana k6 + locust.py - load testing
Last updated