Enterprise Dashboard Platform
The Business Problem
A mid-size logistics company needed a real-time operations dashboard aggregating data from 5+ internal APIs, with role-based access for 200+ employees across 3 departments.
Technical Stack
Architecture
SSR with Next.js App Router feeding real-time Supabase subscriptions. PostgreSQL with RLS enforcing department-level data isolation. Edge-deployed on Cloudflare.
The War Story
API keys silently failing on Cloudflare's edge runtime — variables weren't forwarded to server components at build time. App worked locally, empty data in production. Fix: explicit runtime scoping with NEXT_PUBLIC_ prefix patterns and server-only secret injection.