TorreFuerte POS
Native POS system for hardware stores with a Rust backend, local SQLite persistence, and a React UI.

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS

TorreFuerte POS
01 — The Problem
A real hardware store managed inventory with manual spreadsheets and a web solution that completely failed during internet outages. Every server drop halted sales. The catalog had hundreds of products across multiple units (meters, kilograms, rolls, gallons) with four price tiers (retail, wholesale, distributor, cost). This complexity could not be handled by generic tools without expensive customizations.
02 — Architecture and Solution
I built the app as a native binary using Tauri 2 (Rust) as the main OS process, packaged for Linux (.deb/.rpm) and Windows. The React + TypeScript frontend runs inside an embedded WebView and communicates with the Rust backend via IPC commands (invoke), with no remote server or network dependency for critical flows. The SQLite schema was designed with composite indexes on barcode, internal code, provider, and category to guarantee sub-10ms searches even with thousands of items. WAL (Write-Ahead Logging) pragmas enabled concurrent writes without blocking reads, and bcrypt was used for password hashing for the two user profiles (admin and seller).
03 — Key Technical Decisions
Real-time product search
SQLite indexes on barcode, internal code, name, and provider. Full-text searches resolved in the Rust process and returned to the frontend in under 15ms for catalogs over 5,000 items.
Multiple units of measure and pricing tiers
Typed unit with CHECK constraint in SQLite (UNIT, METER, KILO, ROLL, LITER, GALLON...) and 4 NUMERIC(10,2) price columns with historical cost recorded in each ticket item for real margin reporting.
Exportable financial reports without a server
Integrated the rust_xlsxwriter crate to generate Excel files directly in the native process. Cash closeouts and daily/weekly/monthly/annual reports export to .xlsx without external services.
Ticket printing without external drivers
Native printing module implemented directly with the Windows API (Win32_Graphics_Printing / GDI) as a conditional Cargo dependency. On Linux, the standard CUPS command is used.
Real-time product search
SQLite indexes on barcode, internal code, name, and provider. Full-text searches resolved in the Rust process and returned to the frontend in under 15ms for catalogs over 5,000 items.
Multiple units of measure and pricing tiers
Typed unit with CHECK constraint in SQLite (UNIT, METER, KILO, ROLL, LITER, GALLON...) and 4 NUMERIC(10,2) price columns with historical cost recorded in each ticket item for real margin reporting.
04 — Impact and Results
- >Zero interruptions from network failures - 100% local operation
- >Product searches under 15ms with 5,000+ items
- >Built-in Excel report exports (no server, no cloud)
- >Native ticket printing via Win32 API and CUPS (Linux)
- >Admin / seller roles with bcrypt password hashing
- >Database backup and restore built into the app