Case Study

World Cup Tracker

2026 · Progressive Web AppVisit live site

A Progressive Web App for the 2026 World Cup sticker album: track your collection and duplicates, trade with friends, and predict the knockout bracket with drag and drop.

World Cup Tracker

The problem

Sticker collecting is a social ritual — and the bookkeeping ruins it. Collectors track hundreds of stickers with pen-and-paper lists or spreadsheets, and answering the only question that matters at trade time ("which ones do you have doubled?") means scrolling a chat thread or flipping through the album itself.

It had to work where trading happens: at school, at a café, on someone's phone in the moment. That ruled out anything that only feels good on a desktop.

Key decisions

01

PWA instead of an app store

The whole thing installs from a link and lives on the home screen like a native app. No store review, no download friction — critical when your users are friends you recruit in person.

02

Supabase for accounts and shared state

Auth, the collection data and friend connections live in Supabase. Each collector's counts update live, so two friends comparing albums always see the current truth.

03

Duplicates as a first-class number

The UI tracks how many of each sticker you own, not just whether you have it. Duplicate counts power the trading view: the app can show exactly what you can offer and what you're missing.

04

Friends and alerts built in

A friends system with alerts replaces the group-chat spam: when a friend's collection changes in a way that matters to you, the app tells you — that's the moment a trade happens.

05

A bracket predictor for the fun of it

A drag-and-drop knockout bracket lets collectors predict the tournament itself, giving the app life between sticker packs.

Stack

Next.jsSupabasePWA

Next.js App Router on Vercel as an installable PWA, with Supabase for auth and realtime collection data.

The result

A shipped, installable app ready for the 2026 World Cup: log in, mark your stickers and duplicates, see friends' collections, get alerts, and argue about the bracket. The paper checklist is gone, and trades start from data instead of memory.

PWA
Installs from a link, works like an app
2026
Built for the World Cup
1:1
Trades matched from real duplicate counts

In the wild

World Cup Tracker login screen
Mobile-first from the first screen — accounts keep collections synced across devices.
Next projectSCBorbense Website

Contact

Let's build something together.

Have a project in mind, or just want to say hi? My inbox is always open — I usually reply within a day.

Open to internships & freelance