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.
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.
QuestDB SQL
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.
The next generation has arrived
Upgrade to QuestDB
Hyper ingestion, millisecond queries, and powerful SQL.
Lower bills through peak efficiency.