Projects

A management system for small used bookstores, covering book registration, inventory and a point of sale. It was born because generic POS systems have no notion of a "book" as an item type, and off-the-shelf alternatives were too expensive for a small bookstore. It runs on a VPS I manage myself — nginx as reverse proxy, PostgreSQL as the database, with deployment and backups handled by me.

• Book registration and intake, with shelf settings that keep the physical location consistent
• Inventory control with custom categories and availability filters
• Point of sale: search by name/title, cart and automatic stock deduction on each sale
• Cash register history with amount, date, items and user, filterable by period
• Self-managed infrastructure: firewall, key-based SSH, database backups and security updates

Result: inventory and sales in a single system. Every sale updates stock automatically and the cash report comes out by period, with no side spreadsheet.

A system for the team at a Localiza Seminovos (used car sales) kiosk at Catuaí Shopping, in Londrina, Brazil, to track vehicles in the yard. Tracking used to be manual, which caused inventory mismatches — made worse by the yard being two floors away from the sales team.

• User login with Firebase Authentication; only registered users can make changes
• Real-time sync with Firestore
• Logging of vehicle cleanings and departures, with status lookup (in the yard or not)
• Responsive interface for smartphone, tablet or desktop

Result: manual tracking became a real-time check on the phone. The sales team knows each vehicle's status without walking two floors down to the yard.