Home inventory management system for your pantry & anything with a barcode

I often forget what I have in my home pantry and end up buying more diced tomatoes when I already have 17 cans at home.

This is a simple system that allows me to check what I have in stock from anywhere

• git
• Docker
• docker-compose

git clone [email protected]:ncentola/stockboy.git
cd stockboy

docker-compose up --build

The idea is to have this running on a raspberry pi or similar cheap compute device. Barcode scanning will be done on the edge (rpi) and produce messages for the backend to consume. Eventually the backend consumers & services will most likely be deployed as Fargate services via AWS ECS

Runs on RPi with a USB barcode scanner. The service translates data from the USB barcode scanner into UPC codes and passes to the message queue. RPi will have an in/out toggle for adding and removing from stock

Basic RabbitMQ where a single "scan" goes into a fanout exchange which can then be consumed by the UPC Lookup & Transaction services

Checks if we have the UPC in our system, if not reaches out to a UPC API, retrieves product info, and puts it into the database

Consumes messages produced by the scanner and passes them to the API

Simple routes to interact with the DB

Currently a simple Plotly Dash data table which some search & sort functionality

Simple Postgres db, schemas managed by Flyway

• API Auth
• Multi-tenancy?