Energy monitoring system
Heat, steam and water metering platform for an industrial enterprise
Industrial · energy metering In production
Context
The enterprise ran a legacy metering system on Firebird 2.5 + PHP across two servers. It needed modern monitoring of heat, steam and water across metering devices on several sites — with history, reporting, billing and reliability.
What we built
We built a modern platform to replace the legacy stack. A one-way ETL moves readings from Firebird into PostgreSQL with TimescaleDB; devices update in real time over SSE; on top sit reporting, billing, reconciliation and access control. Multi-tenant architecture: two sites with separate databases.
Capabilities
- Dashboards by resource and site
- Time-series readings on TimescaleDB
- Automated reports and tariff billing
- Data reconciliation
- RBAC (4 roles) and admin audit log
- Firebird ETL, real-time updates (SSE)