I'm a solo developer. This year I shipped Xpect , a football statistics app: for each upcoming professional match it shows probabilities for the usual markets (1X2, over 2.5 goals, both teams to score, corners, cards, offsides) next to the numbers they come from.
This post is about the plumbing: a SQLite file, a Python script on a schedule, one Cloudflare Worker, KV and D1, and the parts that went wrong.
The shape of the system
History lives in one SQLite database: about 1.4 million football matches with scores and, where the source has them, corners, cards and offsides.
The pipeline is a folder of plain Python scripts. No framework, mostly the standard library.
The API is one Worker with KV for precomputed JSON, two D1 databases, a rate limiter and an hourly cron trigger. Live scores come from a third-party API and are cached per edge node for 15 seconds.
The client is an Expo app (SDK 57, React Native 0.86, expo-router, TypeScript).…