FuelFinder
In late 2025, the government announced the Fuel Finder initiative, a public API providing information on the latest fuel prices across the country. This seemed perfect fodder for a project to not only help me and my family out, but get used to proper service management and data warehousing. You can find it at https://fuel.joecase.dev/, and use it free of charge. The site is fully GDPR compliant, no data is stored server side or client side, for it is cookie free.
The project is made up of the following core components:
- Two SSIS jobs
-
- One to fetch the latest prices
- One to fetch the metadata about each fuel station
- The backend API
- The frontend website
The two SSIS jobs connect to the API, handle credential authentication, then storing the data to the database, the API then allows querying this data by postcode, and the frontend handles rendering all of this.
The frontend is made with pure JS (no react used for lightness), and leafletJS to render the map. I originally deployed this back in January 2026, and suffice to say it has become very useful since March 2026.