Expand Supabase sports analytics platform - wordpress + supabase

Here are the project requirements. I already run a Supabase-powered sports analytics platform that pulls live odds through OddsAPI and hosts a functioning Pick Streak Survivor contest. Your job is to extend this existing codebase by adding two new game formats: • Perfect Week Challenge • Monthly Wins Race Both contests must integrate with the existing pick system and produce leaderboard standings that display on the WordPress site. ________________________________________ Backend scope Extend the existing Supabase backend without disrupting the current Pick Streak contest. Tasks include: • Expand or adjust the Supabase schema to support contest entries, weekly streak tracking, monthly win totals, and historical records. • Reuse the existing pick and grading system that already processes game results. • Ingest final game results from OddsAPI and determine win/loss outcomes. • Compute rankings and tiebreakers for both contests. • Write leaderboard results into dedicated Supabase views. • Schedule automated updates using Supabase Edge Functions or cron jobs so the system runs hands-off (for example nightly updates for Monthly Wins and end-of-week evaluation for Perfect Week). ________________________________________ Frontend scope Update the WordPress site to display leaderboard standings for the new contests. Requirements: • Create responsive leaderboard interfaces that load quickly on mobile. • Display player position, streak or win count, and relevant stats such as W/L or completion rate. • Keep the design consistent with the existing site styling. • Show Top 10 players by default with an option to expand. ________________________________________ Deliverables 1. Updated Supabase migrations / SQL schema for the new contests. 2. Automated grading logic using Edge Functions or scheduled jobs. 3. API or RPC endpoints to expose leaderboard data. 4. Leaderboard UI integrated into the existing WordPress site. 5. Brief documentation explaining the grading logic and leaderboard structure. ________________________________________ Goal Extend the existing contest platform so that: • Monthly Wins Race tracks total wins within each calendar month. • Perfect Week Challenge tracks players achieving 7 consecutive winning picks. • Leaderboards update automatically once games are graded. Important: Must include portfolio projects or github. Vercel urls are preferred. Timeline: 3days Budget: $100

Project ID: 40293470