Flickstat
A free, analytics-native football platform — founded it and built the entire stack solo on a 3-person team: a Python data pipeline, a Supabase Postgres backend, and a Next.js frontend on Vercel, with a canonical entity-resolution layer unifying four providers and hybrid ISR/SSR serving 1,000+ pages.
- Next.js
- Supabase
- Python
- Vercel
Football stats are everywhere — but four major providers each call the same player a different name with conflicting IDs. Building anything analytics-grade meant solving that mess first.
Founder & sole engineer on a 3-person team. Owned architecture end-to-end: data ingestion, schema, entity resolution, backend, frontend, deploy, observability.
- 01Wrote a Python pipeline that ingests four provider feeds nightly and normalizes them into a canonical schema
- 02Built an entity-resolution layer (fuzzy match + manual override table) that unifies player/team IDs across sources
- 03Modeled the analytics layer in Supabase Postgres with materialized views for hot paths
- 04Frontend on Next.js (App Router) — hybrid ISR for player/team pages, SSR for live match views, 1,000+ pre-rendered routes
- 05Deployed on Vercel with CI gates on schema drift
Live at flickstat.com — ~1,200 visitors in month one, 2,000+ and counting now, all organic with zero paid acquisition. Now the foundation for the next product layer.


