Sport & Fan
LeaguePages preview
Sport & Fan

LeaguePages

Every non-league table, fixture and result. 22 seasons. Free forever.

Open the live app Built on Base44 — start your own, opens in a new tabBase44 links on this page are affiliate links. If you sign up through one, Dean may earn a commission at no extra cost to you.

Every non-league table, fixture and result across the English pyramid, back 22 seasons, free. The React front end sits on Base44; the data lives in MariaDB behind an Express API on a separate box, fed by scrapers over several sources that routinely disagree. Matches upsert on a dedup key of division-season, home team, away team and date, so most of the work is deciding which source is right — fuzzy team-name matching, ghost-fixture merging with a keeper tie-break, and a cross-validation pass that gets its second opinion from goal events.

Data entities

20

What makes it work

  • Match-day scraping is scheduled off real kick-off times in seven phases — 60-second polls in each half, 180 at half time, a one-shot detail pass at KO+120 — and resumes itself if the server restarts mid-match
  • Cross-validation was rebuilt after 3,776 rows sat permanently 'pending': both sources upsert into the same match row, so the independent check now counts goal events instead
  • Ghost-duplicate merging is restricted to league competitions, because a cup replay is legitimately the same pair again, and it refuses to auto-merge any group holding more than one scored row

How it gets made

Nine parts, in the same order, every time.

Every build on this site comes out of the same structure, whether it is a game, a ledger or a suite of tools. The method is published in full, and so are the prompts I am allowed to publish.

Read the method
A Trusted Media photograph: someone at a desk by a window with a coffee, looking up from the work

Coffee and a problem

More sport & fan

Play Fund Win preview

Play Fund Win

A regulated, multi-tenant fundraising platform used by 1,000+ clubs, charities and foundations.

62 entities

The Vault

You've seen the apps. Take the prompts.

Anyone can describe an app to an AI and get something back. The difference is in the structure — and the structure is what's written down in here.

Every build prompt on this page

Full text, not summaries. Copy and run.

313 production Claude skills

Installed, organised, documented.

The scaffold and the method

How the prompts are structured, so you can write your own.

Unlock the Vault — £79/mo

Cancel any time. Or read the free prompts first — they're the same standard as the paid ones, which is rather the point.