FutureKawa

About the project

Backend for a green coffee stock tracking application spanning three countries (Brazil, Ecuador, Colombia), built as a team for a school project (MSPR). I was responsible for the API and the technical documentation. The architecture is built around a per-country containerized backend (dedicated database, MQTT broker, REST API and alerting microservice), with a central backend aggregating data from all three countries for the frontend. IoT sensors publish temperature and humidity readings over MQTT, automatically triggering email alerts when thresholds are exceeded.

The challenge

The main challenge was fixing data bleed between countries caused by a shared database, by migrating to one dedicated database per country without breaking aggregation on the central backend. I also extracted the alerting logic into an independent microservice to stay aligned with the architecture required by the project brief, and set up Docker Compose to start the entire backend stack (databases, MQTT brokers, APIs, alerting, Mailpit for email testing) with a single command. I also wrote the project's full technical documentation.

Technologies used