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
QuestDB enhances ANSI SQL with time series extensions to manipulate 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;
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.