World Cup Sweepstake
Full-Stack SaaS - Auth & RLS - LLM Newsletters
A multi-tenant World Cup sweepstake platform where admins run a randomized team draw, participants get assigned teams and submit predictions, and everyone follows a live leaderboard with automated email updates.
Architecture
React/Vite frontend with a FastAPI backend on Modal, backed by Supabase auth and PostgreSQL with row-level security for isolated per-admin groups. Features a randomized, frozen team draw, prediction questions, a live leaderboard, and scheduled LLM-generated per-participant email newsletters (via OpenRouter) that snapshot each player's odds, with MongoDB holding fixtures and prediction data.
Results
Runs end-to-end sweepstake groups from draw to leaderboard with automated LLM newsletters.
Highlights
- Randomized, frozen team draw
- Row-level-security multi-tenant groups
- Scheduled LLM email newsletters
Technologies
- React
- Vite
- FastAPI
- Supabase
- PostgreSQL
- MongoDB
- Modal
- LLM
Screenshots
