Case Study
SCBA Guardian
Field + admin platform for breathing-air equipment lifecycle
- Platform
- Web Applications
- Year
- 2026
01 / 06 — Admin dashboard
Select thumbnail · click image to enlarge
Screenshots come from the real applications. Sensitive names, identifiers, and credentials are redacted.
01What it does
Tracks SCBA units, cylinders, and fit tests through their full lifecycle. Firefighters scan QR tags, run pre-shift checks, and file out-of-service reports with photos; admins manage inventory, assignments, tickets, QR label batches, reminders, and a full audit log.
02What I built
- Field app: QR scanning, pre-shift checks, out-of-service reporting, cylinder tracking, and photo attachments
- Admin app: inventory, firefighters, tickets, QR code generation and label batches, reminders, reports, audit log, and settings
- Electron desktop tool that reads the OHD Logic fit-test database read-only and syncs roster and fit-test dates to Supabase
- Data import and label tooling for cylinders, inventory, firefighters, and fit tests
03Key engineering work
- 30+ migrations including an RLS hardening pass, storage role policies, and a private attachments bucket
- Database triggers for out-of-service events and admin ticket creation
- QR label generation tuned for 1/4-inch and 1/2-inch tape, with batch export and retagging
- Windows packaging (portable + NSIS) for the OHD sync tool
04Challenge / Solution
Challenge
Fit-test records live in a third-party desktop application database, but the platform needs them current without manual re-entry.
Solution
A dedicated Electron utility reads the OHD Logic database read-only via sql.js in-process, maps roster and fit-test dates, and syncs them into Supabase - keeping the source system untouched.