F1 Results Tracker

// Overview

A command-line application that lets you browse Formula 1 race data without an internet connection. Results, standings, and team stats are stored in a local SQLite database. Query by season, race, driver, or constructor team. The schema handles multi-driver teams, sprint race results, and the full historical points system going back to the championship's founding.

// Challenges

Designing a CLI that makes hierarchical data (Seasons → Races → Drivers → Lap times) navigable without becoming overwhelming. Keeping SQLite queries fast under complex joins across multiple tables without adding an ORM layer.

// Outcomes

A fast, offline-capable F1 reference tool that runs on any machine with Python installed. The project demonstrated how much can be done with a well-designed schema and plain SQL before reaching for heavier infrastructure.