Desktop App / Offline-First / Cross-Platform

TorreFuerte POS

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

RustTauri 2React 19TypeScriptSQLite (rusqlite)Tailwind CSS 3rust_xlsxwriterbcryptuuidRecharts

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

1 / 4

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.

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
David_Nicanor.dev

$ status --current Available for hire

Insolus Marca
© 2026 David Nicanor. All rights reserved.
Built with Astro · React · TypeScriptHosted on S3 · CloudFront