Problem Statement

Managing sports tournaments is fragmented — organizers rely on WhatsApp groups, spreadsheets, and manual score tracking. With 354+ user submissions and 3 concurrent events, the system needed to be reliable, fast, and role-aware.

Solution

Full-stack tournament system with live scores via Socket.io, role-based access via JWT+bcrypt, Azure SQL for bracket integrity, and Vite code-splitting cutting render time by 50%.

Code Structure

gameon/ client/ components/{Dashboard,Matches,Leaderboard} services/ server/ routes/ controllers/ models/ socket/

Key Strategies

MVC Architecture

Strict MVC separation reduced complexity 40% and onboarded 5 contributors faster.

Azure SQL over MongoDB

Relational integrity critical for bracket foreign keys and JOIN queries.

Socket.io Live Updates

Tournament-namespaced rooms, <100ms latency, boosted retention 45%.

Vite + Skeleton

Code splitting + skeleton screens cut perceived load time 50%.

CI/CD via GitHub Actions

Reduced integration bugs 70%, zero-downtime rollouts.

Technical Challenges

Performance Decisions

API response <100ms. Render time -50% via Vite splitting. Azure SQL query time -35% via indexed joins. CPU -28%.

Trade-offs Made

Azure SQL over MongoDB: relational integrity worth the complexity. Socket.io over SSE for bidirectional future features.

Lessons Learned

Schema design first: rushing caused two costly mid-project migrations. Namespace isolation in Socket.io is non-negotiable.

Future Improvements

React Native app for referees, D3.js analytics dashboard, AI bracket seeding, FCM push notifications, multi-sport support.

Security Considerations

JWT on all routes, bcrypt 12 rounds, CORS whitelisted to prod origin, 100% success in access control tests.

GameON – Sports Tournament Management System