Superior developer experience with SQL and time series extensions. Speed and reliability to solve ingestion speed bottlenecks.
Get QuestDBQuery over 2 billion rows in milliseconds in the QuestDB Web Console using SQL
Try QuestDB demo in your browser
ANSI SQL time series extensions made for time stamped data
SELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
-- Search timeSELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
SELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
-- Slice timeSELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
SELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
-- Navigate timeSELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
SELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
-- Merge timeSELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
Hyper ingestion
For massive volumes of time-series data, trust a specialized time-series database. Timestamps are first-class, and blistering throughput is sustained even through the highest data cardinality. Deduplication and out-of-order ingestion also work right out-of-the-box.
QuestDB is used at Airbus for real-time applications involving hundreds of millions of data points per day. For us, QuestDB is an outstanding solution that meets (and exceeds) our performance requirements.