Sports / Real-Time Platform
Pigeon Premier League
A tournament management and live-scoring platform for endurance pigeon racing, rewritten from a legacy system.
- TypeScript
- NestJS 11
- Prisma 6
- PostgreSQL
- React 18
- Socket.IO
- pg-boss
- Nginx
- GitHub Actions
The problem
The legacy system carried 17 documented correctness and security defects.
What I built
A full rewrite with live leaderboards, race-day time capture and a permission-scoped admin panel, on a three-process architecture over PostgreSQL alone.
My role
- Built and deployed the rewrite
- Three-process architecture
- Cross-process live updates
- Tests and CI/CD pipeline
Technical highlights
- PostgreSQL alone: no Redis or external broker
- WebSocket JSON deltas bridged across processes via LISTEN/NOTIFY
- 128 tests
- Pipeline typechecks, migrates, tests, audits dependencies and auto-deploys over SSH