Jul 2026 – Sep 2026
PGPals
I built and ran the platform for my residence's Emerald Challenge alone, start to closing ceremony. Ninety-six teams played, and the review queue was empty when it closed.
Stack
Next.js, TypeScript, Supabase, PostgreSQL, Tailwind CSS
Links
Notes
Backend, database, deploy, and then the actual running of it: reviewing submissions and fixing whatever broke, for two weeks. The leaderboard went dark before the closing ceremony so the last hour couldn't be gamed, and by the time it closed, nothing was left waiting in the queue. It's offline now, the way a two-week event should be.
The numbers
- Scale
- 164 authenticated users across 96 teams, 2,297 submissions and 3,763 photo/video attachments across 103 challenges.
- Collaboration
- 78 multi-team pairings, 2,196 approved submissions, 2,289 credited team-challenge completions, and 46,540 PGP Coins awarded.
- Moderation
- 10 administrators covered the entire submission workload with a 3.2-hour median turnaround and zero submissions left pending at event close.
- Architecture
- Next.js App Router and TypeScript over Supabase PostgreSQL, Auth, Storage, row-level security, and RPC, deployed in Vercel's Singapore region.