← Back to projects
LSN Hub
Active

A Full Broadcast Network, Built for a Virtual City

LSN Hub is the command center for Los Santos News — a 65-person virtual newsroom inside Highlife RP. What started as a CSV shift tracker is now a full newsroom OS: Claude-powered AI writing, browser-based video-to-GIF via FFmpeg.wasm, a Discord bot that cross-posts breaking news to the Highlife Publications channel, a phased onboarding system with portal tooltips and a three-phase checklist, and an immutable audit trail. 15+ Vercel serverless endpoints, 30+ PostgreSQL migrations, dual-environment deployment on hub.lossantos.news — and a companion public website at lossantos.news.

ReactViteSupabaseClaude APIFFmpeg.wasmDiscord APINext.jsVercel
Dashboard — 8 tools, one newsroom. Each card routes to a specialized module.
100%
👤
Reporter / Admin
hub.lossantos.news
🔐
Supabase Auth
JWT, 24h TTL, force reset
🛡️
Row-Level Security
4-tier via Postgres funcs
🗂️
Profiles Table
Role, Discord ID, certs
📋
Employees Table
Rank, callsign, Steam ID
📊
Shift Analytics
CSV parse + anomaly flags
Phase 0Core PlatformTap a node for details
Key component
Infrastructure
Data flow
Core Platform
Phase 0

The foundation. Supabase Auth with JWT (24h TTL), PostgreSQL Row-Level Security enforcing a 4-tier role hierarchy (Admin > Editor > Creator > Viewer), employee roster with Steam ID matching, and CSV-based shift analytics with anomaly detection.

What Ships
Supabase Auth with email/password + forced password reset gate on first login
Row-Level Security — 4-tier enforcement via is_admin(), is_editor_or_admin(), get_my_role()
Employee Roster — directory with rank, certs, callsigns, Steam name/hex, Discord username
Time Tracker — CSV upload, dual-format parsing (clock events + paired in/out)
Shift Builder — clock in/out pairing with anomaly flags (>4h, <30m, missing clock-out)
Analytics — Recharts area/bar charts with 7d/14d/30d/90d/custom ranges
3-pass auto name matching (exact, normalized, reversed name order)
localStorage fallback + Supabase cloud sync (fast offline, authoritative online)
Impact
LSN staff have secure, role-isolated access to shift data and employee records. Multi-tenancy is structurally enforced at the database — data leaks are impossible by design.