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.