About QuestDB
QuestDB is an open source time-series database built for high write rates and fast SQL queries. It targets market data, sensor streams and other event data that arrives all the time.
What it does
QuestDB ingests large numbers of timestamped rows and makes them available to queries quickly. It uses standard SQL with time-series extensions, so analysts can calculate aggregates over recent or historical data in one place. Out-of-order and duplicate events are handled as they arrive. Data can also be read in open formats such as Apache Arrow and Parquet, which lets other tools work with the same records without a separate export step.
Key features
- High-throughput ingestion of timestamped rows
- SQL queries over live and historical data
- Export to Arrow and Parquet formats
- Handles out-of-order and duplicate events on ingest
- Tiered storage for keeping long history
Who it's for
Trading and financial teams that need tick data, industrial and IoT teams that collect sensor readings, and engineers who want time-series analytics with plain SQL instead of a custom query language.
Pricing and good to know
The core database is open source under the Apache 2.0 license and can be downloaded for free. An Enterprise edition is offered alongside it, and the site lists a free Enterprise trial. Teams running it in production should plan for disk capacity and retention settings, since time-series data grows steadily.
Highlights
- Ingest large streams of timestamped rows
- Query live and historical data with SQL
- Export data as Arrow or Parquet
- Correct late or duplicate events during ingest
- Keep years of history in tiered storage
