What it is
Beacon TCG is a website for Pokémon TCG collectors: look up any card and see its US ($) and EU (€) market prices on the same page, with the finish (regular, reverse holo, holo) and edition, price history, the biggest movers of the month, a Pokédex view, and a free collection and deck manager. It runs on a small self-hosted server.
Why I built it
As a collector I kept two tabs open — one for the US market, one for the European one — and still could not tell whether a card was cheap where I actually buy. I wanted one page per physical card, with both markets, that I could trust. It also became the place where I practise, end to end, the same craft I do at work: making data reliable.
How it works
- Daily pipeline with seven stages: ingest from two public APIs (~177k listings, 1.1 M price rows, 830k price snapshots), normalise every field into columns (raw JSON kept only as an audit copy), link raw sets to a curated canonical catalogue, build one canonical card per physical card, run data-quality rules, download images, publish.
- Two catalogues that do not match. The US and EU sources share no card ids and number cards differently, so cards are unified at a canonical layer with a second source for identity (name, number, rarity, artwork) and marketplace ids as the exact join key.
- Data quality as a first-class layer: nine rules (shared images, duplicate slots, mismatched names or rarities, price outliers, missing images…) reconciled on every run with open/resolved counters, a review queue for uncertain matches, and manual overrides that survive rebuilds.
- Operations: the build runs on my machine and ships as a Docker image to a 1.8 GB VPS; Caddy serves 13 GB of images statically; nightly backups with restore checks; a responsive audit with headless Chromium runs before each deploy.
Status
Public MVP, free to use. Paid plans are on a waitlist until there are enough users to justify billing.