Case Study
Kronus Engineering leverages QuestDB for energy data management
Kronus Engineering designs, packages, and installs containerized battery backup systems. They use QuestDB to manage time-series data in their energy systems, enabling cost-effective real-time monitoring and historical record-keeping on light hardware.
- Real-time analytics
- Receives high volumes of data from sensor arrays across on-prem and off-site ingress infrastructure
- Grafana for visualizations
- Data fuels responsive dashboards served via Grafana
- Low resource deployments
- QuestDB's hardware efficiency provides cost-effective scalability
Efficient energy management
Time-series data, handled with precision
Kronus Engineering leverages QuestDB to receive data from a broad array of inverters, batteries, solar arrays, and other devices which monitor energy grid usage. Data is time-bound for billing and tracking purposes. QuestDB is their go-to solution for time-series database which ensures clean, timely arrival of key data.
- Real-time monitoring
- QuestDB enables Kronus Engineering to process and aggregate time-series data from inverters and other devices instantly.
"Excellent software. Responsive support. Lively community. QuestDB is setting the standard.”
Manage massive sensor arrays
Architecture at a glance
Distributed sensor networks generate tons of data volume.
With many moving parts, integrity and reliability are paramount.
QuestDB behind queues and brokers ensure steady delivery of key data.
With native deduplication and out-of-order indexing, QuestDB is built from
the ground up to keep time as data arrives from any number of sources.
SELECT timestamp,avg(inverter_ac_frq)/100.0 AS "Frequency",last(control_ac_frq)/100.0 AS "Frequency Setpoint",avg(inverter_power_real)/10.0 AS "Real Power"FROM modbus_serverWHERE $__timeFilter(timestamp)SAMPLE BY $__interval
SQL for real-time monitoring
Efficient queries for energy data
Using concuse SQL queries Kronus Engineering to aggregate and monitor key metrics from their energy systems. The SAMPLE BY clause ensures that data is aggregated efficiently via a given time interval. The result? See below!
Real-time in no time
Familiar SQL for Grafana
Kronus Engineering uses Grafana & QuestDB for real-time system monitoring
- Grafana integration
- First-party Grafana integration for real-time dashboards.
- SQL out!
- Query QuestDB via SQL with time-series extensions in real-time.
- Cost effective
- Massive throughput, minimal hardware. Trust your foundation.
"We noticed that other databases performed poorly, specifically in query times. Longer query times had a cascading effect as well (higher cpu/memory usage). QuestDB is superior to any other databases we have benchmarked, and so it is actually reasonable to run it on dedicated low resource devices.”