An open source time-series database for fast ingest and SQL queries
English | 简体中文 | 繁體中文 | العربية | Italiano | Українська | Español | Português | 日本語 | Türkçe | हिंदी
QuestDB
QuestDB is an open-source time-series database for high throughput ingestion and fast SQL queries with operational simplicity.
QuestDB is well-suited for financial market data, IoT sensor data, application metrics, real-time dashboards, and fast analytics.
QuestDB implements ANSI SQL with native time-series SQL extensions. These SQL extensions make it simple to filter and downsample data, or correlate data from multiple sources using relational and time-series joins. We achieve high performance by adopting a column-oriented storage model, parallelized vector execution, SIMD instructions, and low-latency techniques. The entire codebase is built from the ground up in Java and C++, with no dependencies and zero garbage collection.
QuestDB supports schema-agnostic streaming ingestion using the InfluxDB line protocol and a REST API for bulk imports and exports. The QuestDB SQL Web Console is an interactive SQL editor facilitating CSV import. Finally, QuestDB also includes the Postgres Wire Protocol for programmatic queries and interoperability with various tools such as Grafana.
Try QuestDB
We provide a live demo provisioned with the latest QuestDB release and sample datasets:
Query Execution time
SELECT sum(double) FROM trips
0.15 secs
SELECT sum(double), avg(double) FROM trips
0.5 secs
SELECT avg(double) FROM trips WHERE time in '2019'
0.02 secs
SELECT time, avg(double) FROM trips WHERE time in '2019-01-01' SAMPLE BY 1h
0.01 secs
SELECT * FROM trades LATEST ON timestamp PARTITION BY symbol
0.00025 secs
Our demo is running on c5.metal
instance and using 24 cores out of 96.
Get started Install QuestDB
To run QuestDB, Docker can be used to get started quickly:
docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb
macOS users can use Homebrew:
brew install questdb brew services start questdbquestdb start // To start questdb questdb stop // To stop questdb
The QuestDB downloads page provides direct downloads for binaries and has details for other installation and deployment methods.
QuestDB Cloud
QuestDB Cloud is the fully managed version of QuestDB, with additional features such as Role-based access control, Cloud-native Replication, Compression, monitoring and cloud-native snapshots. Get started with $200 credits here
Connect to QuestDB
You can interact with QuestDB using the following interfaces:
9000
9009
8812
9000
Insert data
Below are the official QuestDB clients for ingesting data via the InfluxDB Line Protocol:
End-to-end quickstart
Want to walk through everything, from streaming ingestion to visualization with Grafana? Check out our multi-path quickstart repository.
How QuestDB compares to other open source TSDBs
This article compares QuestDB to other open source time series databases spanning functionality, maturity and performance.
Here are high-cardinality
Time Series Benchmark Suite
results using the cpu-only
use case with 6 to 16 workers on 32 CPUs and 64GB RAM:
<a href="https://github.com/questdb/questdb/blob/master/.github/readme-benchmark.png" rel="nofollow"></a>
Resources 📚 Read the docs
❓ Get support
🚢 Deploy QuestDB
Contribute
We welcome contributions to the project, whether source code, documentation, bug reports, feature requests or feedback. To get started with contributing:
✨ As a sign of our gratitude, we also send QuestDB swag to our contributors. Claim your swag here.
A big thanks goes to the following wonderful people who have contributed to QuestDB: (emoji key):
clickingbuttons
💻 🤔 📓
Yitaek
✅ 💡
gabor-boros
✅ 💡
kovid-r
✅ 💡
TheTanc
📆 🖋 🤔
Ugbot
💬 📓 📢
tiagostutz
📓 🐛 📆
fuzzthink
🤔 📓
zanek
🤔 📆
Geekaylee
📓 🤔
ultd
🤔 📆
giovannibonetti
📓 🐛 📆
pswu11
🖋 🤔 🎨
tris0laris
📝 🤔
This project adheres to the all-contributors specification. Contributions of any kind are welcome!
Twice a month we will interview people behind open source businesses. We will talk about how they are building a business on top of open source projects.
We'll never share your email with anyone else.