Real-time analytics dashboard on a Postgres replica with sub-second refresh and role-based access.
Year2024
RoleFull-stack developer
TypeInternal tool
Status
Live
Overview
About this project.
Operations team was running Grafana plus a homegrown PHP dashboard and neither matched the views they actually used in standups. Goal: replace both with one tool whose primary user is the on-call engineer at 3am.
Built on Next.js App Router with a streaming server component layer that pushes Postgres LISTEN/NOTIFY events through Server-Sent Events. Sub-second refresh without polling.