Event Scoring

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

Event example

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

Express.js Swagger MicrosoftSQLServer GitHub

  • mocha + supertest + chai - endpoint testing

  • grafana k6 + locust.py - load testing

Last updated