# questdb
**Repository Path**: mirrors_trending/questdb
## Basic Information
- **Project Name**: questdb
- **Description**: QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No
## Statistics
- **Stars**: 9
- **Forks**: 1
- **Created**: 2020-07-31
- **Last Updated**: 2025-09-06
## Categories & Tags
**Categories**: database-service
**Tags**: None
## README
English |
简体中文 |
繁體中文 |
العربية |
Italiano |
Українська |
Español |
Português |
Français |
Deutsch |
日本語 |
한국어 |
עברית |
Nederlands |
Türkçe |
हिंदी |
Tiếng Việt |
Bahasa Melayu
---
QuestDB is an open-source time-series database offering blazingly fast ingestion
and dynamic, low-latency SQL queries.
QuestDB delivers a multi-tier storage engine (WAL → native → Parquet on object storage),
and the core engine is implemented in zero-GC Java and C++; QuestDB Enterprise includes additional components in Rust.
We achieve high performance via a column-oriented storage model, parallelized
vector execution, SIMD instructions, and low-latency techniques. In addition,
QuestDB is hardware efficient, with quick setup and operational efficiency.
> Ready to go? Jump to the
> [Get started](#get-started) section.
QuestDB Web Console - click to launch demo
## Benefits of QuestDB
Feature highlights include:
- Low-latency, high-throughput ingestion — from single events to millions/sec
- Low-latency SQL with time-series extensions (ASOF JOIN, SAMPLE BY, LATEST ON)
- SIMD-accelerated, parallel execution
- Multi-tier storage: WAL → native columnar → Parquet (time-partitioned and time-ordered)
- Postgres protocol (PGwire) and REST API
- Materialized views and n-dimensional arrays (incl. 2D arrays for order books)
- Web console for queries and data management
- Apache 2.0 open source and open formats — no vendor lock-in
- [Finance functions](https://questdb.com/docs/reference/function/finance/) and [orderbook analytics](https://questdb.com/docs/guides/order-book/)
QuestDB excels with:
- financial market data (tick data, trades, order books, OHLC)
- Sensor/telemetry data with high data cardinality
- real-time dashboards and monitoring
And why use a time-series database?
Beyond performance and efficiency, with a specialized time-series database, you
don't need to worry about:
- out-of-order data
- deduplication and exactly one semantics
- Continuous streaming ingest with many concurrent queries
- streaming data (low latency)
- volatile and "bursty" data
- adding new columns - change schema "on the fly" while streaming data
## Try QuestDB, demo and dashboards
The [live, public demo](https://demo.questdb.com/) is provisioned with the latest
QuestDB release and sample datasets:
- Trades: live crypto trades with 30M+ rows per month (OKX exchange)
- FX order book: live charts with orderbook FX pairs.
- Trips: 10 years of NYC taxi trips with 1.6 billion rows
We also have some public, real-time demo dashboards using
our [Grafana-native](https://questdb.com/docs/third-party-tools/grafana/) plugin:
- [Real-time crypto trades:](https://questdb.com/dashboards/crypto/) executed
trades on OKX from more than 20 assets in real time
- [FX order book:](https://questdb.com/dashboards/FX-orderbook/) live depth/imbalance charts for major FX pairs
### QuestDB performance vs. other databases
QuestDB performs very well in performance benchmarks compared to alternatives.
For deep dives into internals and performance, see the following blog posts:
- [QuestDB vs InfluxDB](https://questdb.com/blog/2024/02/26/questdb-versus-influxdb/)
- [QuestDB vs Kdb+](https://questdb.com/compare/questdb-vs-kdb/)
- [QuestDB vs TimescaleDB](https://questdb.com/blog/timescaledb-vs-questdb-comparison/)
- [QuestDB vs MongoDB](https://questdb.com/blog/mongodb-time-series-benchmark-review/)
As always, we encourage you to run your own benchmarks.
## Get started
Use [Docker](https://www.docker.com/) to start quickly:
```bash
docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb
```
Or macOS users can use Homebrew:
```bash
brew install questdb
brew services start questdb
```
```bash
questdb start
questdb stop
```
Alternatively, to kickoff the full onboarding journey, start with our concise
[quick start guide](https://questdb.com/docs/quick-start/).
### First-party ingestion clients
QuestDB clients for ingesting data via the InfluxDB Line Protocol:
- [Python](https://questdb.com/docs/clients/ingest-python/)
- [.NET](https://questdb.com/docs/clients/ingest-dotnet/)
- [C/C++](https://questdb.com/docs/clients/ingest-c-and-cpp/)
- [Go](https://questdb.com/docs/clients/ingest-go/)
- [Java](https://questdb.com/docs/clients/java_ilp/)
- [NodeJS](https://questdb.com/docs/clients/ingest-node/)
- [Rust](https://questdb.com/docs/clients/ingest-rust/)
### Connect to QuestDB
Interact with QuestDB and your data via the following interfaces:
- [Web Console](https://questdb.com/docs/web-console/) for an interactive SQL
editor and CSV import on port `9000`
- [InfluxDB Line Protocol](https://questdb.com/docs/reference/api/ilp/overview/)
for streaming ingestion on port `9000`
- [PostgreSQL Wire Protocol](https://questdb.com/docs/reference/api/postgres/)
for programmatic queries on port `8812`
- [REST API](https://questdb.com/docs/reference/api/rest/) for CSV import and
cURL on port `9000`
### Popular third-party tools
Popular tools that integrate with QuestDB include:
- [Kafka](https://questdb.com/docs/third-party-tools/kafka/)
- [Redpanda](https://questdb.com/docs/third-party-tools/redpanda/)
- [Grafana](https://questdb.com/docs/third-party-tools/grafana/)
- [Polars](https://questdb.com/docs/third-party-tools/polars/)
- [Pandas](https://questdb.com/docs/third-party-tools/pandas/)
- [PowerBI](https://questdb.com/docs/third-party-tools/powerbi/)
- [Superset](https://questdb.com/docs/third-party-tools/superset/)
- [Apache Flink](https://questdb.com/docs/third-party-tools/flink/)
- [Telegraf](https://questdb.com/docs/third-party-tools/telegraf/)
- [MindsDB](https://questdb.com/docs/third-party-tools/mindsdb/)
### End-to-end code scaffolds
From streaming ingestion to visualization with Grafana, start with code
scaffolds in from our
[quickstart repository](https://github.com/questdb/questdb-quickstart).
### Configure QuestDB for production workloads
Find our
[capacity planning](https://questdb.com/docs/deployment/capacity-planning/) to
fine-tune QuestDB for production workloads.
### QuestDB Enterprise
For secure operation at greater scale or within larger organizations.
Additional features include:
- high Availablity and read replica(s)
- multi-primary ingestion
- cold storage integration
- role-based access control
- TLS encryption
- native querying of Parquet files via object storage
- support SLAs, enhanced monitoring and more
Visit the [Enterprise page](https://questdb.com/enterprise/) for further details
and contact information.
## Additional resources
### 📚 Read the docs
- [QuestDB documentation:](https://questdb.com/docs/) begin the journey
- [Product roadmap:](https://github.com/orgs/questdb/projects/1/views/5) check
out our plan for upcoming releases
- [Tutorials:](https://questdb.com/tutorial/) learn what's possible with QuestDB,
step by step
### ❓ Get support
- [Community Discourse forum:](https://community.questdb.com/) join technical
discussions, ask questions, and meet other users!
- [Public Slack:](https://slack.questdb.com/) chat with the QuestDB team and
community members
- [GitHub issues:](https://github.com/questdb/questdb/issues) report bugs or
issues with QuestDB
- [Stack Overflow:](https://stackoverflow.com/questions/tagged/questdb) look for
common troubleshooting solutions
### 🚢 Deploy QuestDB
- [AWS AMI](https://questdb.com/docs/guides/aws-official-ami)
- [Google Cloud Platform](https://questdb.com/docs/guides/google-cloud-platform)
- [Official Docker image](https://questdb.com/docs/get-started/docker)
- [DigitalOcean droplets](https://questdb.com/docs/guides/digitalocean)
- [Kubernetes Helm charts](https://questdb.com/docs/guides/kubernetes)
## Contribute
Contributions welcome!
We appreciate:
- source code
- documentation (see our
[documentation repository](https://github.com/questdb/documentation))
- bug reports
- feature requests or feedback.
To get started with contributing:
- Have a look through GitHub issues labelled
"[Good first issue](https://github.com/questdb/questdb/issues?q=is%3Aissue+is%3Aopen+label%3A%22Good+first+issue%22)"
- For Hacktoberfest, see the relevant
[labelled issues](https://github.com/questdb/questdb/issues?q=is%3Aissue+is%3Aopen+label%3Ahacktoberfest)
- Read the
[contribution guide](https://github.com/questdb/questdb/blob/master/CONTRIBUTING.md)
- For details on building QuestDB, see the
[build instructions](https://github.com/questdb/questdb/blob/master/core/README.md)
- [Create a fork](https://docs.github.com/en/github/getting-started-with-github/fork-a-repo)
of QuestDB and submit a pull request with your proposed changes
- Stuck? Join our [public Slack](https://slack.questdb.com/) for assistance
✨ As a sign of our gratitude, we send QuestDB swagto our contributors!
A big thanks goes to the following wonderful people who have contributed to
QuestDB [emoji key](https://allcontributors.org/docs/en/emoji-key):
This project adheres to the
[all-contributors](https://github.com/all-contributors/all-contributors)
specification. Contributions of any kind are welcome!