The Challenge
A regional equipment dealership needed a way to modernize their in-store displays across multiple locations. What started as a simple request for digital signage quickly evolved into something more ambitious: they wanted staff to be able to cast their screens during customer consultations, all managed centrally by their marketing department.
The twist? The client specifically requested a database-less architecture. They wanted full control over their data in human-readable formats, easy backups, and zero database maintenance overhead. Every location also needed to function independently if internet connectivity was lost.
The Approach
The solution required a hybrid architecture: lightweight local servers at each location handling real-time WebRTC communication, paired with a central web application for content management and distribution.
Local Node.js Instances
Each location runs a Node.js application that handles:
- Subnet-scoped WebRTC signaling so staff can cast their screens to any display within the local network with near-zero latency
- Local asset caching that keeps displays showing content even during internet outages
- Heartbeat monitoring to keep the central server informed of each location's display status
- Secure pairing using a simple PIN-based system for authorized screen casting
Central Web Application
The PHP/JavaScript web application serves as the command center:
- Marketing portal with drag-and-drop content scheduling, display previews, and instant updates to all locations or specific stores
- Location management showing real-time status of every display across all locations, grouped by region
- Asset library providing centralized storage for videos, images, and dynamic content templates
- Role-based access where marketing managers see everything while location managers see only their store
- Audit logging that tracks who changed what and when
Database-less Architecture
All data stored in structured JSON files:
- Display configurations including screen layouts, rotation schedules, and assigned content
- User accounts with secure password hashing, role assignments, and session management
- Content metadata covering asset information, scheduling rules, and location assignments
- Activity logs containing timestamped records of all system events
This approach delivered exactly what the client wanted: configuration files they could read, backup with a simple copy, and restore without database expertise.
Technical Highlights
WebRTC Implementation
- STUN/TURN server integration for NAT traversal
- Automatic quality adjustment based on network conditions
- Sub-second latency for live screen casting
- Graceful fallback when peer connection fails
Real-time Sync
- WebSocket connections between central server and local instances
- Immediate content push so displays update within seconds of hitting "publish"
- Conflict resolution for simultaneous edits
- Offline queue for updates when locations reconnect
Security Considerations
- All WebRTC traffic encrypted end-to-end
- Local casting restricted to authenticated devices on the same subnet
- Central admin protected with rate-limited authentication
- No sensitive data exposed in JSON files (hashed credentials, no PII in logs)
The Results
- 14 locations deployed and managed from a single dashboard
- > 30 displays running synchronized content across all stores
- < 2 second average time from "publish" to on-screen update
- 99.7% uptime including graceful offline operation
- Zero database maintenance since the client manages backups with simple file copies
- High staff adoption with screen casting becoming the most-used tool during customer equipment demos
What Made This Project Unique
The database-less requirement initially seemed like a constraint, but it became a feature. The client's IT team can inspect, modify, and backup configurations without any specialized tools. When they opened a new location, deployment was as simple as copying a folder and updating a single config file.
The WebRTC integration transformed what could have been a passive digital signage system into an interactive sales tool. Staff now regularly cast equipment spec sheets, comparison charts, and video demos directly to the displays during customer conversations.
