questdb
QuestDB is a high performance, open-source, time-series database
What is questdb?
QuestDB is a high performance, open-source, time-series database
Overview of questdb
What it is
QuestDB is an open-source, low-latency time-series database that uses open formats. It ingests millions of events per second, computes on live data in milliseconds, and keeps years of history queryable. One SQL engine spans ingestion, stream processing, and tiered storage.
Key features
- Open-source, low-latency time-series database with open formats (Parquet, Iceberg, Arrow).
- Peak ingestion of 19 million rows per second per instance (measured on QuestDB 10.0 over QWP).
- Query results streamed to Arrow at 220 million rows per second; 500 million rows streamed in 2.3 seconds.
- Zero-GC Java engine with C++ and Rust on hot paths; memory-mapped, time-partitioned columns; SIMD and JIT-compiled filters.
- Tiered storage: parallel write-ahead log, native columnar partitions, and Apache Parquet. Open source allows manual conversion to Parquet; Enterprise automates cold partition tiering to object storage.
- Standard SQL extended with time-series functions: SAMPLE BY, LATEST ON, ASOF JOIN, WINDOW JOIN, HORIZON JOIN, materialized views, live views, and n-dimensional arrays.
- Native QuestDB Wire Protocol (QWP) for binary columnar writes and reads over WebSocket; also supports PostgreSQL Wire Protocol, InfluxDB Line Protocol, and REST API.
Use cases
- Capital markets: tick data, order books, trades, pre-trade analysis, post-trade analytics.
- Aerospace and robotics: flight-test telemetry, fleet data, mission replay.
- Energy and infrastructure: reactor, turbine, and grid telemetry at full resolution.
- AI coding agents: through QuestDB skills and MCP server.
Getting started
Use Docker to start quickly:
docker run -p 9000:9000 -p 8812:8812 questdb/questdb
Or macOS users on Apple Silicon can use Homebrew:
brew install questdb
brew services start questdb
questdb start
questdb stop
QuestDB bundles native libraries for Apple Silicon only. On an Intel Mac, use the Docker image above.
License and pricing
License: Apache-2.0. Pricing: open source (free).
Based on the project's public README and repository metadata.