Show HN: A website for comparing Nespresso capsules
If there are any Nespresso lovers here, you might want to check out a website my wife made for comparing Nespresso capsules — https://www.nespressocapsules.coffee. It's a Python-based web application that extracts data from www.nespresso.com/tw/en (in Taiwan, caffeine content must be clearly labeled by law), processes it, and displays it through a responsive HTML interface. The backend is entirely implemented using Azure Functions. Data is stored in an SQLite database in Azure Blob Storage — same goes for capsule images, which are processed and resized using the Pillow library before being saved there. The application generates dynamic HTML tables, uses a Bootstrap theme for a modern look, and JavaScript for sorting the table by any column. Static content is served through Cloudflare with caching enabled to reduce latency and bandwidth usage. Cloudflare also handles HTTPS redirects.
The idea for the project came about when we wanted to compare how much caffeine is in different Nespresso capsules. I knew about the spreadsheets by Alvin Bunk (https://docs.google.com/spreadsheets/d/1kZJCdTmqQla2ha3DDYyi...) and that it's possible to build a scalable app using Azure Functions — and do it on the cheap. So she put the two together and built something (hopefully) useful.
How did you measure the caffeine content in the capsule? Also, I assume that is the total amount of caffeine present in the capsule, and not the caffeine dissolved in a cup of coffee (since that would depend on the amount of water running through it, and possibly on temperature and mineral contents as well.)