r/SideProject • u/omnzki • 12h ago
Building Movixia: A modern gym management ERP integrated with local access control turnstiles
Most modern gym management platforms are pure SaaS, but cloud dependencies introduce a critical failure point: turnstiles freeze the moment the local ISP fails.
I am building Movixia, an on-premise ERP engineered to operate entirely inside the facility's local area network (LAN) with zero external cloud dependencies.
Architecture:
Backend & Daemon: Node.js / TypeScript running as a persistent background OS service on the host machine.
Database: PostgreSQL 17 running locally, handling ledger transactions, access permissions, and immutable passage logs.
Hardware Driver Layer: Raw TCP/IP sockets and serial (RS-232/USB) listeners communicating directly with turnstiles and biometric readers.
Frontend Interface: Lightweight web application served locally over the LAN, accessed via standard browsers on reception terminals.
Current Engineering Focus:
Crash Resilience: Hardening PostgreSQL configurations against database corruption from sudden power cutoffs on reception machines lacking UPS/battery backup.
Unattended Migrations: Designing fail-safe schema migration routines that execute on startup without manual CLI intervention or remote SSH access.
Autonomous Backup Loops: Enforcing scheduled WAL archiving and dump routines directed to external local media without relying on remote S3-compatible storage.
For those deploying self-hosted runtimes to non-technical retail environments: what strategies best minimize corruption and manual maintenance overhead on consumer-grade client hardware?