04Full-Stack·2023
AquaSafe
Real-time water-quality monitoring across a distributed sensor network.
- <1s
- Alert latency
- 50+
- Sensor streams
- 3rd
- of 200+ systems
AquaSafe takes high-frequency data from a network of water sensors and turns it into something a person can watch in real time. The question was how to get from 50+ noisy streams to a sub-second alert without drowning in the data.
The build
I designed a MySQL schema tuned for time-series queries across 50+ streams, which got alerting under a second. The React and Node platform shows live and historical data on interactive dashboards, pulling from a multi-station network for centralized monitoring and anomaly detection.
Recognition
It placed 3rd of 200+ systems at the SEECS Open House 2023. The unglamorous schema work is what made the demo feel instant.