questdb /questdb
QuestDB is a high performance, open-source, time-series database
★ 17,530⑂ 1,698👁 134⑃ 5,258● 2,957▤ 113
+0
Daily
17,530
stars
1,698
forks
134
watchers
5,258
prs
2,957
issues
113
releases
README
English |
简体中文
---
QuestDB is the open-source, low-latency time-series database on 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.
The engine is zero-GC Java with C++ and Rust on the hot paths. Data lives in
memory-mapped, time-partitioned columns. Queries run across all cores with SIMD
and JIT-compiled filters. There are no third-party dependencies on the data
path.
Storage is tiered: a parallel write-ahead log, native columnar partitions,
and Apache Parquet. In open source you convert partitions to Parquet with
ALTER TABLE, or create a table in Parquet directly. QuestDB Enterprise
converts cold partitions automatically and tiers them to object storage.
Parquet, Apache Iceberg, and Apache Arrow keep the data open to any tool.
Measured on QuestDB 10.0 over QWP:
| | | Source |
|---|---|---|
| Peak ingestion per instance | 19M rows/sec | QWP vs ILP ingestion benchmark |
| Query results streamed to Arrow | 220M rows/sec | Streaming 500 million rows into Arrow |
| 500M rows streamed | 2.3 s | same post |
| First Arrow batch | 32 ms | same post |
Get started
Use Docker to start quickly:
bash
docker run -p 9000:9000 -p 8812:8812 questdb/questdb
Or macOS users on Apple Silicon can use Homebrew:
bash
brew install questdb
brew services start questdb
bash
questdb start
questdb stop
QuestDB bundles native libraries for Apple Silicon only. On an Intel Mac, use
the Docker image above.
For the full walkthrough, start with the
quick start guide.
QuestDB Web Console - click to launch demo
New in QuestDB 10.0: the QuestDB Wire Protocol (QWP), one binary
columnar protocol for writes and for Arrow reads, plus native arrays and
live views in beta.
Release notes.
Ingress and egress over QWP
QWP is a binary columnar protocol over WebSocket. The same connection writes
rows in and streams query results back out as columns. The Python client
returns those columns as Apache Arrow by default, and Rust and C/C++ can
enable it with a flag.
On the way in, the
QWP vs ILP ingestion benchmark
measures 19M rows/sec over the network, and that peak holds from one
thousand to one million series. On the way out,
Streaming 500 million rows into Arrow
measures 220M rows/sec with eight readers, with the first batch after 32 ms
and client memory flat however large the result. The
QWP overview
covers the protocol design.
What QuestDB does
One engine covers the full lifecycle of the data:
- Capture. Ingest millions of ordered and out-of-order events per second
without pre-aggregation. Deduplication and out-of-order correction are built
in.
- Compute. Transform, enrich, and aggregate events as they arrive.
Materialized views
aggregate by time slice, many rows in and one row out.
Live views run wTop issues
#1631Add all-contribs 🎉 65 comments · 2021-11-30#3727About "could not get table writer"31 comments · 2023-09-09#2202recent unsafe memory access operation in compiled Java code31 comments · 2022-06-08#5812function.cursorClosed() not called consistently25 comments · 2025-07-04#3816Table partitions for all tables in the QuestDB21 comments · 2023-10-05#1679SQL: Join Column Type Mismatch21 comments · 2021-12-13#4120Port remaining parallelizable aggregate functions to off-heap data structures18 comments · 2024-01-11#2189could not open read-only [file=/home/tey/.questdb/db/stock_history/default/change_percent.d16 comments · 2022-06-05
Discussions
#7881QuestDB in a CodeLaser <> Claude Code benchmark1 comments · 2026-10-12#7607QuestDB 10.0.1 on Windows Docker: V9FS corruption disappeared with Linux/ext4 Docker volume0 comments · 2026-09-06#6646Keep Sender Object Alive1 comments · 2026-01-14#6447Proposal: Security Assessment from Team Atlanta (DARPA AIxCC)3 comments · 2025-11-25#5956Production Usage in Aviation & Border Systems: Clarification on Replication / HA Roadmap2 comments · 2025-07-17#5635QuestDB as a Railway.app template0 comments · 2025-04-29#5511Data Ingest via curl / PHP?1 comments · 2025-03-25#5468SAMPLE BY months FROM-TO for multiple unique regions0 comments · 2025-03-14
Latest release
10.2.0 10.2.0 2026-11-10QuestDB 10.2.0 QuestDB 10.2.0 adds GROUPING SETS, ROLLUP and CUBE, row-level retention for materialized views, a DEDUP SKIP mode that keeps the first-written row, and opt-in power-loss durability for WAL tables, enabled with cairo.commit.mode=adaptive. QWP ingestion of small messages is much faster, and this release fixes a large batch of wrong-result, crash and hang bugs in queries, out-of-order ingestion and Parquet partitions. This release contains a few breaking changes. Read the Breaking changes section before you upgrade, especially if you create materialized views with LIMIT or wi