Progress update, 5 Aug 2026

Updates are bullet-point summaries generated with AI from my commits and build notes, then checked by me. Project articles and learning notes are written by me.

Rewrote the global rankings as three SQL queries plus a Python pass. 31 corners and 14 straights matched the old output exactly. The only grandstand differences were nine floating point artefacts the old code had been shipping, such as 14.399999999999999.
ORDER BY g.grandstand_id, gv.rowid reproduced the old list ordering with zero differences across 29 grandstands.
Grandstand lookups were keyed by code, which is only unique per circuit. Forcing a collision merged two grandstands (28 instead of 29). Now keyed by grandstand_id, changed in a single commit, because the halfway state deleted a grandstand instead.
The circuit page, still on the old pipeline, listed two spreadsheet typos as straights that the new rankings page correctly dropped. Fixed the typos in the source workbook rather than rushing the migration.
Those typos were cells showing 9-10 that held dates under a d\-m number format. Set them to strings with Text format; database validation went to 0 mismatches.
See Migrating by predicted diffs.