DBPOS (Zero-Config Desktop POS)

1. Problem

Deploying Sasuai v1 and HallRoastery required installing web servers (XAMPP), configuring PHP, and setting up MySQL databases on the client's local machines. This required high technical skills, making it impossible to scale software distribution to non-technical business owners.

2. Solution

Architected a stripped-down, highly focused desktop POS application. By dropping complex features like membership tiers and bundling the database natively, the application became a "plug-and-play" executable file (.exe) requiring zero technical configuration from the end-user.

3. Architecture

• Desktop Wrapper: Electron.js
• Frontend: React.js
• Local Backend: Express.js (Bundled inside Electron)
• Database: SQLite (Embedded)

4. Key Engineering Decisions

• Embedded SQLite: Replaced MySQL with SQLite to eliminate the need for a database server installation. The database lives as a local file, ensuring perfect offline capability and zero-config setup.
• Feature Pruning for Stability: Intentionally removed complex CRM and multi-store features to guarantee absolute system stability for standalone, single-store mom-and-pop shops.

5. Challenges

• Managing state communication between the React frontend and the Express/SQLite backend entirely over Electron's Inter-Process Communication (IPC) channels without introducing latency.
• Ensuring ACID compliance and preventing database corruption if the desktop machine unexpectedly lost power.

6. Result

• Created a completely self-contained, installable retail product that could be distributed directly to users without on-site technical support.
• Proved the viability of the Electron/React stack for POS hardware interactions.

7. Future Improvements

• Project Evolved: The local-only limitation of DBPOS directly inspired the hybrid cloud-desktop architecture of Sasuai App v2 for multi-store syncing