Case study 08 / 37
DataConstruct
A manufacturing platform built around one loop (plan, actual, variance, why, action, result), with finite-capacity scheduling and tenant isolation enforced by PostgreSQL row-level security.
- Status
- In development
- Domain
- Web · Cloud · Security
- Source of claims
- Private repository README (reviewed). Source and deployment are not public.
ERP, MRP, MES and quality management for manufacturers: BOMs, routings, yield, costing, capacity and variance, with a drag-and-drop Gantt scheduler, offline operator mode and a grounded assistant.
01/The problem
Factories know what should happen and, eventually, what did, but rarely why the two differ. DataConstruct is built around closing that loop on the shop floor.
02/The system
ERP, MRP, MES and quality management for manufacturers: BOMs, routings, yield, costing, capacity and variance, with a drag-and-drop Gantt scheduler, offline operator mode and a grounded assistant.
03/Scope
- 01Pure calculation engines for BOM, yield, cost, variance, MRP, capacity and root cause, in Decimal maths.
- 02Production scheduling with finite capacity, conflict detection and a drag-and-drop Gantt.
- 03Quality, downtime and CAPA workflows; offline operator mode with documented sync and conflict rules.
- 04A demo company loaded by driving the real API, so every figure comes from the same workflows a user runs.
04/Engineering
Isolation the database enforces
Tenant requests run through a role subject to PostgreSQL row-level security, and the API refuses to start if that role could bypass it.
Migrations that keep their guards
Append-only triggers and frozen standards live in hand-reviewed migrations; tests create, migrate and drop their own uniquely named database.
05/Interface
Interface screenshots of this commercial product are not public. The visual above is an abstract representation of its modules — not the product itself.
06/Tech stack
- NestJS
- Next.js
- TypeScript
- Prisma
- PostgreSQL (row-level security)
- Redis
- BullMQ
- Decimal maths
07/Result
Verified outcomes
- 149 unit tests for the calculation engines, plus API integration tests against real PostgreSQL.
Known limitations
- Not yet ready for real customer data: onboarding, backups and production providers are still open.
08/Links
Private commercial codebase — no public links.
Related work
B2B airline ticketing platform
TimeTravel →
Multi-tenant B2B airline ticketing: agent booking portal, admin dashboard, agency wallets with credit lines, and a pluggable flight-provider layer.
Commercial · private
Multi-vendor marketplace
Kinamna →
A multi-vendor marketplace for Nepal: storefront, seller portal and superadmin console on one 183-endpoint API, with tamper-proof Khalti, eSewa and Fonepay payments.
Private · Deployed
Travel ticketing & finance system
Geoland System →
Ticketing, supplier and finance system for a Nepal-based travel business, with per-currency supplier ledgers, signed private attachments, WhatsApp confirmations and an end-to-end test suite.
Private · Deployed
Next case study
DataItemize →