# 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
QuestDB Logo

 

QuestDB open source contributors

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 showing a SQL statement and query result

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.
A chart comparing the ingestion rate of QuestDB, InfluxDB and TimescaleDB.
## 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):

clickingbuttons

💻 🤔 📓

ideoma

💻 📓 ⚠️

tonytamwk

💻 📓

sirinath

🤔

igor-suhorukov

💻 🤔

mick2004

💻 📦

rawkode

💻 🚇

solidnerd

💻 🚇

solanav

💻 📖

shantanoo-desai

📝 💡

alexprut

💻 🚧

lbowman

💻 ⚠️

chankeypathak

📝

upsidedownsmile

💻

Nagriar

💻

piotrrzysko

💻 ⚠️

mpsq

💻

siddheshlatkar

💻

Yitaek

💡

gabor-boros

💡

kovid-r

💡

TimBo93

🐛 📓

zikani03

💻

jaugsburger

💻 🚧

TheTanc

📆 🖋 🤔

davidgs

🐛 🖋

kaishin

💻 💡

bluestreak01

💻 🚧 ⚠️

patrickSpaceSurfer

💻 🚧 ⚠️

chenrui333

🚇

bsmth

📖 🖋

Ugbot

💬 📓 📢

lepolac

💻 🔧

tiagostutz

📓 🐛 📆

Lyncee59

🤔 💻

rrjanbiah

🐛

sarunas-stasaitis

🐛

RiccardoGiro

🐛

duggar

🐛

postol

🐛

petrjahoda

🐛

t00

🐛

snenkov

📓 🐛 🤔

marregui

💻 🤔 🎨

bratseth

💻 🤔 📓

welly87

🤔

fuzzthink

🤔 📓

nexthack

💻

g-metan

🐛

tim2skew

🐛 📓

ospqsp

🐛

SuperFluffy

🐛

nu11ptr

🐛

comunidadio

🐛

mugendi

🤔 🐛 📖

paulwoods222

🐛

mingodad

🤔 🐛 📖

houarizegai

📖

jjsaunier

🐛

zanek

🤔 📆

Geekaylee

📓 🤔

lg31415

🐛 📆

null-dev

🐛 📆

ultd

🤔 📆

ericsun2

🤔 🐛 📆

giovannibonetti

📓 🐛 📆

wavded

📓 🐛

puzpuzpuz

📖 💻 📓

rstreics

💻 🚇 📖

mariusgheorghies

💻 🚇 📖

pswu11

🖋 🤔 🎨

insmac

💻 🤔 🎨

eugenels

💻 🤔 🚧

bziobrowski

💻 📆

Zapfmeister

💻 📓

mkaruza

💻

DylanDKnight

📓 🐛

enolal826

💻

glasstiger

💻

argshook

💻 🤔 🎨 🐛

amunra

💻 📖 🐛

GothamsJoker

💻

kocko

💻

jerrinot

💻 🤔 🐛

rberrelleza

💻

Cobalt-27

💻

eschultz

💻

XinyiQiao

💻

terasum

📖

PlamenHristov

💻

tris0laris

📝 🤔

HeZean

💻 🐛

iridess

💻 📖

selmanfarukyilmaz

🐛

donet5

🤔 🐛

Zahlii

🐛

salsasepp

🐛

EmmettM

🐛 ⚠️

robd003

🤔

AllenEdison

🐛

CSharpDummy

🐛

shimondoodkin

🐛 🤔

huuhait

🐛 🤔

alexey-milovidov

🐛

suconghou

🐛

allegraharris

💻

oliver-daniel

💻

kerimsenturk5734

📖
This project adheres to the [all-contributors](https://github.com/all-contributors/all-contributors) specification. Contributions of any kind are welcome!