I built this project to brush up on my SQL skills and get more comfortable working with real-world style datasets. It uses a PostgreSQL database containing historical Formula 1 race data from 1950 to 2022, which I expose through a lightweight API and query to produce simple driver performance summary tables.
The app lets you select a season and a metric, such as average finishing position or points per race, and it returns aggregated results for all drivers in that year. On the backend, I use SQL queries in PostgreSQL to group, filter, and compute these statistics efficiently.
The front end is a lightweight JavaScript interface that sends requests to an API endpoint and dynamically updates the table without reloading the page. The goal was to keep things simple and focus on solid database querying and clean data flow from database to UI.
| Driver | Races | Value |
|---|