Built with
Offline desktop application for multi-company sales, purchase, and materials management, built for a client whose operations could not depend on connectivity.
Offline-first is a genuine architectural constraint rather than a feature toggle. There is no server to arbitrate conflicts and no network round trip to fall back on, so the local database is the source of truth and every operation has to complete correctly without one. That shapes the whole design.
The app handles several companies inside a single interface, each password-protected so data stays confidential between entities that may share a machine but not an owner. Sales and purchase tracking cover transaction management, with detailed vouchers and per-company pages built around widgets that surface the numbers people check most often.
Local backup and restore is the safety net. When the data lives on one machine, backup is not an operational nicety, it is the only thing standing between the client and total loss, so it was built to be something a non-technical user would actually perform rather than a documented procedure nobody runs.
Built on Reactron Base, a custom open-source Electron boilerplate I maintain, with React, Electron, SQLite, Tailwind CSS, TypeScript, Material-UI, and Knex. SQLite is the right database for this shape of problem: a real relational engine with transactions, in a single file the user can copy.
The engagement had a constrained budget, and the interesting outcome is that a deliberately scoped MVP still delivered full value. The client was extremely satisfied and keen to continue. Limited features executed properly beat a broad feature list executed thinly.
Private engagement, case study available on request.
More work