MPIA Services
A multi-platform operations system for a non-destructive testing company doing radiographic inspection on rail turnouts, pipelines, and industrial steelwork. A central PostgreSQL database drives the office, client, and public surfaces, while the field app captures offline to local SQLite and syncs back when online.
- Role
- Software Developer · Contract via Rephina Software
- Problem
- MPIA ran inspections, client reporting, field capture, and their web presence across disconnected tools. They needed every surface — office staff, clients, and technicians in the field — reading and writing to one consistent source of truth.
- Scale
- 7 surfaces · 4 form factors · central PostgreSQL DB with offline SQLite sync
- Outcome
- MPIA's platform connects internal operations, client access, field data capture, reporting, and public web presence — office and client surfaces on one central PostgreSQL database, with the field app syncing from offline SQLite.
The 7 surfaces
- 01Admin Web App — operations console for MPIA staff
- 02Admin Desktop — native Windows shell of the admin app
- 03Portal Web App — client-facing, tenant-scoped access
- 04Portal Desktop — native Windows shell of the portal
- 05Portal Mobile — Flutter read-mostly client app
- 06Field Mobile — Flutter offline-first capture app
- 07Marketing Website — public site + installer/update host
Key features
- Jobs, clients, depots, equipment, technicians
- Weld sets, joints, and joint interpretations
- Reports, invoices, and quotes
- Audit logs and granular permissions
- CMS that drives the marketing site
- Tenant-scoped client portal (isolation re-checked per row, never from the token)
- Offline-first field capture to local SQLite, synced when online
- Tauri desktop shells with single-instance lock and signed auto-updates
Architecture
- Next.js 15 web apps deployed on Vercel
- Flutter mobile apps (Android / iOS) over a /api/mobile sync layer
- Tauri 2 desktop shells wrapping the hosted web apps
- PostgreSQL with Prisma as the single schema source of truth
- Shared workspace packages: database, auth/guards, audit logging, UI
- Ed25519-signed desktop installers + update manifests served from the site



