Historical data
Jolpica → Python ETL → DuckDB / Parquet → statistics tools + RAG
FastF1 → batch import → box-box → comparative dashboards
Bringing industrial data engineering to a motorsport laboratory: historical data, game telemetry, reliable replay and AI-assisted lap experiments. Eight connected components, built and explained in public.
GitHub ↗ Milestones and evidenceStatus · 13 October 2026. ETL implementation, a Rust historian v1 and isolated Python prototypes are in progress. The integrated live pipeline, AI lap optimisation and motion rig have not been demonstrated. The architecture below is the target design; repository code and evidence determine completion.
Jolpica → Python ETL → DuckDB / Parquet → statistics tools + RAG
FastF1 → batch import → box-box → comparative dashboards
F1 game / recorded capture → UDP capture + fan-out → edge connector → box-box → dashboard
The capture path must preserve session identity, source timestamps and data quality. Durable recovery is a planned requirement; the current buffer is in memory.
Game and real-world laps can be aligned for exploration, but they have different physics, conditions and sampling. Motion cues derived from public data are an optional research extension, not a reproduction of actual driver forces.
A monorepo with eight cases. Prototype code is evidence of progress, not a claim of production readiness.
Implementation in progress: layered historical ETL. The component README tracks execution evidence and remaining backfill.
v1 implemented and exercised locally: HTTP ingest with validation, per-tag swinging-door compression, WAL + Parquet segments, restart recovery and a query API with downsampling. Pending: FastF1 batch importer, per-tag retention and runs against real game packets.
Header parsing, tag mapping, exception filtering and an in-memory buffer prototype. Packet-body decoding, UDP capture and historian integration remain to be built.
Dashboard scaffold. Planned comparisons by lap distance, with source, quality and replay state visible.
Health endpoint scaffold. Planned read-only statistics tools, cited narrative retrieval and a versioned evaluation set.
Script validation, distance-based interpolation, position-hold and edit prototypes. No connected game-control loop yet; repeatability and input adapters need validation.
Later phase: degradation models and simulator-to-real-data experiments. Generalisation is a research question, not an established result.
Later phase: a client for stable platform APIs. Motion-rig research is a separate, optional extension.
A series by Rodrigo Manso, supported by DeepCode. Videos in English for YouTube and Instagram, following actual implementation milestones. Portuguese subtitles may be added when useful.
Why this lab • Reading the first packets • Sessions, clocks and data quality • Recording and replaying a lap.
Storage and recovery • Compression versus fidelity • A repeatable baseline • AI edits with measured outcomes and visible failures.
Follow the series on YouTube and Instagram. Episodes are in preparation. Explore the code and milestones on GitHub.
Repository code and data have different licenses. Jolpica data is subject to CC BY-NC-SA 4.0; FastF1’s MIT software license does not establish blanket rights to underlying telemetry. Each dataset and any published footage needs its own attribution and permitted-use review.