The story
- 01 · Problem
Foreign workers for local employers: passports, visas, permits, contracts. Everything in spreadsheets; expiries missed; files scattered; two people overwriting each other.
- What had to change
- Four document types with expiry rules; placement history; who may see and change what; the system must run in the office with nothing exposed to the internet.
- 02 · System
A management system on a server in their office, with their brand: workers, documents with expiry alerts, contracts and files per worker, staff accounts, a history of every change, automatic backups.
- Connected
- Office network; nightly backups; email.
- Automated
- Expiry alerts on the dashboard; a record of who changed what.
- 03 · Implementation
Backend with hand-written migrations, real-time invalidation and locks, files per worker, spreadsheet exports, an admin backups page, a one-script installer, one-command update, guarded rollback.
- 04 · Result
Running on the client's office network under their brand. Still in development; the list of what's missing is kept next to the code.
Technical detail
- Architecture in detail
- Single-tenant template: the same code installed per client, branded by a first-run wizard; a five-state expiry rule with a configurable threshold; pessimistic locking; an audit diff on every change.
- Layers
- Business Architecture Software Data Infrastructure Security
- Stack
- NestJS React PostgreSQL nginx Ubuntu