APP_01 // LIVEDATA
Cover Next
Which game is worth a video right now?
A free site for gaming YouTubers. Every day it compares each game's Wikipedia views for the last 7 days against the 7 before, next to the most-watched YouTube videos about it from the past week.
- Python
- dbt
- BigQuery
- Terraform
- Next.js
WHAT IT DOES
- Games are labelled rising, steady or cooling from the Wikipedia change. Search, sort and a watchlist kept in your browser.
- YouTube videos are shown one by one with their own view counts, never added up across channels.
- Game identity from IGDB through a deterministic resolver: 200 frozen labelled cases, 0 false automatic merges. Uncertain records go to quarantine.
- A daily GitHub Actions run collects the data in Python and publishes the site. dbt models on BigQuery, GCP managed in Terraform.
- No accounts, no cookies, no analytics.
SPEC // COVER NEXT
- STATUS
- Live, updated daily
- STACK
- Python, SQL, dbt, Next.js
- CLOUD
- GCP: BigQuery, Terraform
- SOURCES
- Wikimedia, YouTube, IGDB
- SITE
- cover-next.krishnachittella.dev
- REPO
- github.com/KrishnaChittella/cover-next