High performance time series database

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.

Read the docs

Using QuestDB, we deliver time series datasets with real-time market data from a top 10 blockchain. This outperforms a legacy cloud-based data platform at a fraction of the cost, reducing TCO by >90%.

Daniel Siedentopf — Senior Software Developer, XRP Ledger Foundation

QuestDB performance compared to TimescaleDB and InfluxDB. QuestDB is the clear winner.

QuestDB is a time series database truly built by developers for developers. We found that QuestDB provides a unicorn solution to handle extreme TPS while also offering a simplified SQL programming interface.

>Viet Lee
CTO, Aquis Exchange

Augmented SQL for time series data

ANSI SQL time series extensions made for time stamped data

SELECT timestamp, tempC
FROM sensors
WHERE timestamp IN '2021-05-14;1M';

-- Search time
SELECT timestamp, tempC
FROM sensors
WHERE timestamp IN '2021-05-14;1M';

SELECT timestamp, avg(tempC)
FROM sensors
SAMPLE BY 5m;

-- Slice time
SELECT timestamp, avg(tempC)
FROM sensors
SAMPLE BY 5m;

SELECT timestamp, sensorName, tempC
FROM sensors
LATEST ON timestamp PARTITION BY sensorName;

-- Navigate time
SELECT timestamp, sensorName, tempC
FROM sensors
LATEST ON timestamp PARTITION BY sensorName;

SELECT sensors.timestamp ts, rain1H
FROM sensors
ASOF JOIN weather;

-- Merge time
SELECT sensors.timestamp ts, rain1H
FROM sensors
ASOF JOIN weather;

Search Time

Filter and search for specific timestamps with “WHERE”

Slice Time

Create time buckets and aggregate by intervals with “SAMPLE BY”

Navigate Time

Search time series from most recent values to oldest with “LATEST ON”

Merge Time

Join two tables based on timestamp where timestamps do not exactly match with “ASOF JOIN”

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.

>Oliver Pfeiffer
Software Architect, Airbus

Available everywhere

Open Source & Enterprise

Deploy QuestDB anywhere around the world.

Open source: Always open source. QuestDB is licensed under Apache 2.0, for worry-free, developer-friendly usage.
Enterprise: Premium features like Role-based Access Control and database replication means scale on your own terms.

Switching to QuestDB was a game-changer for our analytics. With Elasticsearch, we faced slow ingestion and latency issues for queries. With QuestDB, we now process billions of records per day smoothly.

>Ajay Pilaniya
Lead Media Analytics, Airtel

Ready to upgrade?

Break free from ingestion speed bottlenecks

Spin up in minutes

Download QuestDB

High performance time series database

Performance

Developer experience

Enterprise ready

Try the live demo

Use QuestDB with the tools you love

Peak performance time-series