Menu

How one scheduled Python job and a single Cloudflare Worker serve football stats for hundreds of matches a week
📰

How one scheduled Python job and a single Cloudflare Worker serve football stats for hundreds of matches a week

DEV Community: reactnative·Xpect·7 days ago
#exPbAHIU
#devtoreactnative#devto#dev#match#matches
Reading 0:00
15s threshold

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).…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.