Files
poli0981andClaude Opus 5.5 ec1bf939f6 docs: split CHANGELOG.md into one file per release
changelog/v<major>/<major>.<minor>.x/<version>.md for each of the 42
releases from v1.0.0 to v4.7.1, and changelog/beta/ for pre-releases
(none has been published; its README says how one would be filed).
CHANGELOG.md becomes the index: what the layout is, [Unreleased] exactly
as it was, and a table per major version (version, date, edition) that
links each file.

Each file is its section, copied byte for byte except that its heading
is the file's H1 (so the sub-headings move up one level, outside code
fences), relative links gain ../../../ so they name the same repository
paths, and the --- separators between sections are gone. Checked by
reversing all three changes on every file and comparing with the
original section: 40 of 40 equal. Two releases had no section: v1.0.0
(its GitHub release notes, which the changelog pointed to as "Initial
stable") and v1.1.3 (its tag message).

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-17 09:02:37 +07:00

11 KiB
Raw Permalink Blame History

v4.0.0 – 2026-09-17 (The "Rewrite" Edition)

All versions

The end-user web app was rewritten from React 19 to SvelteKit 2 / Svelte 5, given a typeface and a palette of its own, and gained the pages it had been missing. /admin was rebuilt as an app of its own, embedded in the Worker. The data path now verifies every shard it caches, every game has a page search engines can read, the web app is installable, and the desktop app updates itself. Web app + desktop/Android bumped 1.4.5 → 2.0.0; repo public-facing version 3.4.3 → 4.0.0.

Breaking for anyone who packaged or embedded the old build: the desktop window is now resizable, the tauri-plugin-http native bridge is gone, and the Content-Security-Policy is emitted by the app itself rather than by _headers.

Deploying it needs one manual step: npx wrangler d1 migrations apply f2p-admin --remote (migration 0002_admin_state.sql). The Worker runs without it, degraded, and /admin/health says so.

🎨 A front end that looks like something

  • Rewritten on SvelteKit 2 + Svelte 5 runes. 30 routes, prerendered to static HTML — every page now ships real markup to a crawler instead of an empty shell. React, react-router, zustand, TanStack Query, cmdk and Radix are gone; Bits UI, @tanstack/svelte-virtual and svelte-sonner replace them.
  • Three self-hosted typefaces, subsetted to Latin, Latin-Ext and Vietnamese: Bricolage Grotesque for display, IBM Plex Sans for body and the 3,666-row table, JetBrains Mono for figures. The old build declared Inter and shipped no font file at all, so it had always rendered in system-ui.
  • A warm amber palette, replacing the Tailwind 3 defaults the previous version kept "until the palette rework", plus a skip link, a :focus-visible rule and a prefers-reduced-motion block — none of which had ever existed.
  • A brand mark that is geometry, not a font glyph. The old icon drew "▶" as SVG <text> in system-ui: a different shape on every platform, and tofu where no font supplied it.

📄 New pages

  • /legal/:doc — all eight documents, rendered from the repo's markdown at build time, so no markdown parser or sanitiser reaches the browser. The welcome screen used to intercept these links and redirect to /about.
  • /games/:appid — a real page per game, prerendered for all ~3,600 games from build-time seeds with VideoGame structured data, and listed in the sitemap. Player counts and reviews still come live from the catalogue.
  • /welcome — a first-run introduction, shown once after the terms are accepted: what the list is and is not, three ways in, the language, and the documents just accepted.
  • /legal — an index of the documents. An unknown document is a translated 404 rather than the dashboard.
  • /developers, /developers/:name, /publishers/:name — developer[] and publisher[] were on every record and used by nothing.
  • /stats — the fields no chart covered: Metacritic distribution, peak-vs-now retention, safety flags, language coverage, review-label buckets, and when games went quiet.
  • /charts/time gains catalogue growth (added per month, running total), and the anti-cheat index is a searchable, sortable table.

🔎 Findable

  • Open Graph and Twitter cards on every page. There were none, so a shared link rendered as a bare grey URL everywhere. og:image is a real 1200×630 PNG — it used to point at an SVG, which no social platform renders.
  • Canonical URLs on every page, not just /games/:appid.
  • sitemap.xml generated from the route table. The old one listed four URLs, three of them pointing at github.com, and none of the app's own routes.
  • PNG icons for the PWA manifest and apple-touch-icon, which never accepted SVG.

🛠️ /admin rebuilt

  • Its own app. The two Worker-rendered pages (1,400 lines of HTML and script inside template literals) are replaced by a Svelte 5 app in web/admin/, embedded in the Worker and served only behind Cloudflare Access, with a nonce-only script policy. None of it reaches dist/, the service worker or the packaged apps, and the build fails if any does.
  • Decided rows are read-only. Approved, committed and rejected rows, and undecided rows for a game that is already published, have no checkbox and are skipped by select-all. The server enforces the same rules from one shared module, and every row a decision cannot touch comes back with a reason instead of being dropped silently.
  • Reopen a rejected row from its details, with the reason when it cannot be.
  • Every decision is confirmed first; tabs, search, sort and page live in the URL; keyboard shortcuts; a phone layout.
  • Corrections are reviewed as a diff before the commit, bulk changes can set or retire any field across pages, and a settled override file can be deleted.
  • Jobs, Audit and Health have their own pages. Health still draws its table when the answer is a 503, and Test write proves the write path.
  • Deferring or requeueing a failed row next to an open one no longer 500s; an approval whose commit landed but whose queue update failed says exactly that and leaves its job marked committed.
  • Reconcile holds a D1 lease, sweeps undecided rows whose game appeared in data/ by another route, and skips the dataset fetch while nothing changed.
  • audit_log and commit_jobs are pruned after 180 days, as the privacy policy now says.
  • npm run dev:admin runs the real handlers against an in-memory database, so the admin can be worked on without deploying it.

🧮 Data you can trust

  • data/index.json carries a SHA-256 per shard, and last_updated changes only when the data did — a pipeline run that changed nothing no longer makes every visitor re-download ~6 MB.
  • The Worker serves ?v=<sha256> shard requests content-addressed and immutable, and refuses (503) while GitHub's CDN still has the previous bytes.
  • The app caches only a generation whose hashes verified, keeps the last good one for offline use, and re-checks when the tab comes back. A long-lived tab used to show a count and date days out of date.

📲 Installable, and updatable

  • The web app registers its service worker (it never had, on the SvelteKit build), offers installation, works offline, and asks before reloading into an update.
  • The desktop app updates itself: it checks a feed at /api/updates/desktop, which offers only a published desktop-v* release, shows the notes, and restarts into the new version. The old endpoint pointed at the repository's "latest" release, usually a dataset release, and 404'd.
  • Updating no longer wipes settings: the webview is cleared once, only when coming from a build older than 2.0.
  • steam:// links open the Steam client from the apps.

🔐 Security

  • A negative limit disabled the SQL bound. Math.min(Number("-1") || 50, 200) is -1, and SQLite treats a negative LIMIT as unlimited — so ?limit=-1 dumped the entire never-pruned audit log. Clamped.
  • A token with a missing or non-numeric exp never expired. exp is now required and numeric.
  • The JWT is no longer accepted from a cookie on writes. Only the Cf-Access-Jwt-Assertion header, which browsers never send cross-site.
  • A signing-key rotation locked out admin and ingest for up to an hour as an opaque 404; the JWKS is refetched once on an unknown kid, and a fetch failure is now a 503 rather than "not found".
  • Every server crash was reported to the reviewer as "Session expired" — the admin pages sniff Content-Type, and an unhandled throw became Cloudflare's HTML 1101 page. There is a top-level handler now.
  • A reject can no longer downgrade an approved game, which would have made it permanently invisible to every future discovery sweep.
  • header_image is validated as an HTTPS Steam CDN URL, not merely length-capped.

✅ Tests, where there were none

docs/ADMIN.md claimed the override byte-parity between scripts/edit_game.py and the Worker was "asserted by a parity test". No test existed anywhere in the repo. Vitest now covers the app, the Worker (against a real SQLite database with the real migrations) and the admin app; pytest covers the index hashing; cargo covers the upgrade purge. The first 95 were each checked by mutation, not merely by passing. verify-dist.mjs reads the built HTML in CI for the mistakes that only exist there.

🖥️ Binary 2.0.0

  • The window unlocks. It was pinned to exactly 1400×900, non-resizable and non-maximisable, which made a responsive redesign pointless on the one platform that could not use it. Now 1280×860, resizable, minimum 880×600.
  • tauri-plugin-http removed along with its https://github.com/* capability. It existed for the GitHub OAuth Device Flow, which went with sign-in; the only remaining GitHub call is the Android release check, which is a plain fetch to an endpoint that sends CORS headers.
  • Real paths, no hash router. tauri::manager::get_asset() resolves /games/730 through its own fallback chain; the note claiming the webview had no server-side fallback was out of date. Links from released 1.4.x builds are still upgraded on load.

🐛 Fixed on the live site

  • Raw placeholders on screen: Languages ({{count}}), (PEAK {{PEAK}}) as a field label, (peak {{peak}}) on a chart axis, and one in a prerendered meta description. A test now reads every call site.
  • Hovering a chart tile, bar or slice blanked it (the colour format zrender cannot parse), the genre treemap tooltip printed ({d}%), and axis names were clipped on /stats.
  • The command palette crashed on open (a duplicate route), the consent overlay covered the documents it asked people to read, unknown URLs rendered the dashboard, and old /#/ links changed the address bar without the page.
  • Vietnamese readers saw English for the legal document names, the table's data-issue hints and the About page's stack. 137 locale keys nothing used any more are gone, and a test fails on the next one.
  • The report-only CSP messages in the console come from Cloudflare's Continuous script monitoring, not the site; docs/SECURITY_SETUP.md says how to turn it off.

🐛 Console

Every reported error is fixed, and each was measured rather than assumed:

  • GitHub avatars were blocked by CSP on /activity. They are proxied through the Worker at /img/gh/*, so img-src stays 'self'.
  • The Cloudflare Access re-auth fetch was blocked. It uses a full-page redirect now.
  • [Violation] 'setTimeout' handler took 122ms — zero long tasks while four charts initialise, because each waits for an IntersectionObserver instead of all of them racing in one frame.
  • [Violation] non-passive 'mousewheel' listener — zrender binds both wheel and mousewheel with no options object, unconditionally. Four blocking listeners for two charts, measured; now zero.

📇 Contact

The maintainer address is contact@poli0981.dev; every other channel is https://poli0981.dev/links/. CODE_OF_CONDUCT.md had no reporting address at all. /.well-known/security.txt exists and is served as text/plain — it used to return the app shell with HTTP 200.