QuestDB

QuestDB logo

QuestDB

A time-series database built for very fast ingestion and SQL queries over market, sensor and metrics data.

Upvote

QuestDB is a database specialised for data that arrives with a timestamp: trades, IoT readings, application metrics and logs. It pairs a column-oriented storage design with a SQL layer that has extra syntax for time-based questions, so downsampling and joining on time need only a few lines.

Speed where it counts

The core is written in low-level Java with native code for the hot paths, using vectorised execution to scan columns quickly. Ingestion accepts the InfluxDB line protocol, so existing collectors can point at it with little change, while analysts can connect through the PostgreSQL wire protocol and query with familiar tools.

  • High-throughput ingestion with out-of-order data handling
  • SQL extensions such as SAMPLE BY and ASOF JOIN
  • Web console for running queries and importing CSV files
  • Partitioning and data retention by time

It is commonly used in capital markets, industrial monitoring and observability, as a lightweight alternative to proprietary time-series platforms.

Key Features

  • Column-oriented storage tuned for time-series
  • InfluxDB line protocol and PostgreSQL wire protocol support
  • Time-aware SQL such as SAMPLE BY and ASOF JOIN
  • Built-in web console
  • Time-based partitioning
  • Parquet and Arrow related integrations
  • Docker and single-binary installs

Frequently Asked Questions

Is QuestDB free and open source?

Yes, QuestDB is open source. It is released under the Apache-2.0 license.

What can I use instead of Kdb+?

You can use QuestDB as a free, open-source alternative to Kdb+.

Can I self-host QuestDB?

Yes, QuestDB can be self-hosted on your own server or cloud infrastructure.

What is QuestDB written in?

It is built using Java, Rust, C, Assembly, C++.

Leave a Review

Share your experience with QuestDB. Your review will be published after moderation.