NYX System: Multi-Tenant Industrial ERP / CRM / MES Platform

Task

Industrial manufacturing facilities often suffer from friction between administrative offices and shop floors: manual paper logs cause inventory mismatches, editable databases undermine financial auditability, and exposed customer details risk trade secret theft. The objective was to architect and deploy a modular, multi-tenant ERP/MES platform on Go and PostgreSQL uniting sales orders, inventory, floor machinery, and fiscal accounting in real time with paranoid security.

Solution

The backend adheres to Clean Architecture in Go, utilizing a Contract-First methodology where OpenAPI schemas serve as the single source of truth for typed handlers. The system enforces strict ledger immutability: direct deletions are blocked at the database engine level, requiring reverse corrective ledger entries ("Storno") with explicit audit stamps. Multi-tenant partitioning guarantees customer isolation, while factory floor PWA tablets operate in Privacy Mode with anonymized order tags (#ORD-2026-404) to prevent customer list theft.

Architecture & Network Isolation

┌──────────────────────────────────────┐       Contract-First API       ┌──────────────────────────────────────┐
│       Management ERP Dashboard       │ ────────────────────────────►  │           Go Core Backend            │
│   (Finances, Analytics, Customers)   │ ◄────────────────────────────  │       (Clean Architecture)           │
└──────────────────────────────────────┘                                └──────────────────┬───────────────────┘
                                                                                           │
┌──────────────────────────────────────┐       Privacy Mode (< 0.1s)                       │
│        Shop-Floor PWA Terminal       │ ◄─────────────────────────────────────────────────┤
│    (Anonymized Orders #ORD-404)      │                                                   │
└──────────────────────────────────────┘                                                   ▼
                                                                        ┌──────────────────────────────────────┐
                                                                        │           PostgreSQL 16              │
                                                                        │  (RLS Multi-Tenancy + Storno Ledger) │
                                                                        └──────────────────────────────────────┘

Integrity & Security Architecture

Operational Scenario	Legacy ERP Systems	NYX System
Defective Batch Correction	Direct table deletion/overwrites (high fraud risk)	Immutable Storno: Reverse ledger entry with actor stamp
Shop Floor Terminals	Client identities & commercial rates exposed	Privacy Mode: Floor machinsts see only anonymized work orders
Disgruntled Employee Offboarding	Sabotage risks via record deletion	Soft Delete: Permanent deletion impossible without owner key

Key Features

• Go Clean Architecture: High-throughput Contract-First backend maintaining sub-0.1s response latency between office and shop floor.
• Immutable Accounting (Storno): Direct data deletion prohibited; complete audit trail of corrective adjustments eliminates inventory fraud.
• Privacy Mode: Anonymized work order identifiers on floor devices shield client names and financial pricing from floor staff.
• JSONB Schema Extensions: Dynamic routing and BOM (Bill of Materials) customization without triggering schema migrations.
• Shop-Floor PWA: Resilient touchscreen interface designed for factory floor tablets and gloved industrial operations.

Technologies

Architecture and Deployment

Packaged into isolated Docker containers with segmented networking. The deployment fully integrated warehouse raw materials ingestion, compounding recipe validation, vulcanization machinery telemetry, and automated dispatch documentation.

← Back to all projects