Live: WNBA player-prop board and Supabase migration

Production work for a US sports-analytics client, now on a third consecutive contract.

What it is. Python ETL and scraping pipelines feeding a live WNBA player-prop model, plus a full PostgreSQL/Supabase migration with row-level security and a scheduled job that refreshes the board every morning. The front end is a dark, sortable prop board with per-player sparklines, book line versus projection colouring and a click-through player detail panel, deployed as a standalone page that updates on every push.

The bug worth telling you about. I found a scoring column silently returning 0 for every single row. One line selected a DataFrame column by position, and after an upstream schema change it landed on the wrong one. Nothing errored. The dashboard had looked fine the whole time.

That is the reason every pipeline I build ships with a verification layer rather than just tests that pass. A pipeline that fails loudly is a good day; a pipeline that is quietly wrong costs a client months.