App Milagros
Local-first, fully offline point-of-sale and inventory system for a hair-products store.
- Type
- Commercial (freelance)
- Status
- In production
- Year
- 2026
- Role
- Lead Full Stack Developer
- Stack
- Node.js
- Express 5
- SQLite (better-sqlite3)
- JavaScript
- HTML5
- CSS3
- PDFKit
- ExcelJS
- bcrypt
- @yao-pkg/pkg
Problem
The business, a hair-products store in San Roque, Antioquia, needed to track sales, inventory and credit without relying on internet access and on low-spec machines.
Solution
Local-first, 100% offline POS and inventory system, packaged as an .exe for machines with 4 GB of RAM.
Features
- Products and stock
- Barcode scanner
- Credit sales and debtor tracking
- Invoicing with an 80 mm thermal printer
- Receipts by email
- Reports and history
- Export to Excel and PDF
- Automatic backups
Technical decisions
SQLite instead of PostgreSQL
It is a lightweight database bundled in the same package as the application, so nothing has to be installed on the client's machine.
Performance on 4 GB of RAM
The client's machine had that limitation, so unnecessary work was reduced on both the server and the client. For example, product images were left out to keep the system lightweight.
My role
Lead Full Stack Developer — architecture, database, frontend, backend, unit tests, optimization, packaging and on-site installation. One other person contributed 4 user stories.
Gallery
Links
- Repositoryhttps://github.com/Brayhan23/app-milagros