Skip to content

questdb/questdb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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 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 and orderbook analytics

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 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 plugin:

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:

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 to start quickly:

docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb

Or macOS users can use Homebrew:

brew install questdb
brew services start questdb
questdb start
questdb stop

Alternatively, to kickoff the full onboarding journey, start with our concise quick start guide.

First-party ingestion clients

QuestDB clients for ingesting data via the InfluxDB Line Protocol:

Connect to QuestDB

Interact with QuestDB and your data via the following interfaces:

Popular third-party tools

Popular tools that integrate with QuestDB include:

End-to-end code scaffolds

From streaming ingestion to visualization with Grafana, start with code scaffolds in from our quickstart repository.

Configure QuestDB for production workloads

Find our 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 for further details and contact information.

Additional resources

📚 Read the docs

❓ Get support

🚢 Deploy QuestDB

Contribute

Contributions welcome!

We appreciate:

To get started with contributing:

✨ 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:

Image
clickingbuttons

💻 🤔 📓
Image
ideoma

💻 📓 ⚠️
Image
tonytamwk

💻 📓
Image
sirinath

🤔
Image
igor-suhorukov

💻 🤔
Image
mick2004

💻 📦
Image
rawkode

💻 🚇
Image
solidnerd

💻 🚇
Image
solanav

💻 📖
Image
shantanoo-desai

📝 💡
Image
alexprut

💻 🚧
Image
lbowman

💻 ⚠️
Image
chankeypathak

📝
Image
upsidedownsmile

💻
Image
Nagriar

💻
Image
piotrrzysko

💻 ⚠️
Image
mpsq

💻
Image
siddheshlatkar

💻
Image
Yitaek

💡
Image
gabor-boros

💡
Image
kovid-r

💡
Image
TimBo93

🐛 📓
Image
zikani03

💻
Image
jaugsburger

💻 🚧
Image
TheTanc

📆 🖋 🤔
Image
davidgs

🐛 🖋
Image
kaishin

💻 💡
Image
bluestreak01

💻 🚧 ⚠️
Image
patrickSpaceSurfer

💻 🚧 ⚠️
Image
chenrui333

🚇
Image
bsmth

📖 🖋
Image
Ugbot

💬 📓 📢
Image
lepolac

💻 🔧
Image
tiagostutz

📓 🐛 📆
Image
Lyncee59

🤔 💻
Image
rrjanbiah

🐛
Image
sarunas-stasaitis

🐛
Image
RiccardoGiro

🐛
Image
duggar

🐛
Image
postol

🐛
Image
petrjahoda

🐛
Image
t00

🐛
Image
snenkov

📓 🐛 🤔
Image
marregui

💻 🤔 🎨
Image
bratseth

💻 🤔 📓
Image
welly87

🤔
Image
fuzzthink

🤔 📓
Image
nexthack

💻
Image
g-metan

🐛
Image
tim2skew

🐛 📓
Image
ospqsp

🐛
Image
SuperFluffy

🐛
Image
nu11ptr

🐛
Image
comunidadio

🐛
Image
mugendi

🤔 🐛 📖
Image
paulwoods222

🐛
Image
mingodad

🤔 🐛 📖
Image
houarizegai

📖
Image
jjsaunier

🐛
Image
zanek

🤔 📆
Image
Geekaylee

📓 🤔
Image
lg31415

🐛 📆
Image
null-dev

🐛 📆
Image
ultd

🤔 📆
Image
ericsun2

🤔 🐛 📆
Image
giovannibonetti

📓 🐛 📆
Image
wavded

📓 🐛
Image
puzpuzpuz

📖 💻 📓
Image
rstreics

💻 🚇 📖
Image
mariusgheorghies

💻 🚇 📖
Image
pswu11

🖋 🤔 🎨
Image
insmac

💻 🤔 🎨
Image
eugenels

💻 🤔 🚧
Image
bziobrowski

💻 📆
Image
Zapfmeister

💻 📓
Image
mkaruza

💻
Image
DylanDKnight

📓 🐛
Image
enolal826

💻
Image
glasstiger

💻
Image
argshook

💻 🤔 🎨 🐛
Image
amunra

💻 📖 🐛
Image
GothamsJoker

💻
Image
kocko

💻
Image
jerrinot

💻 🤔 🐛
Image
rberrelleza

💻
Image
Cobalt-27

💻
Image
eschultz

💻
Image
XinyiQiao

💻
Image
terasum

📖
Image
PlamenHristov

💻
Image
tris0laris

📝 🤔
Image
HeZean

💻 🐛
Image
iridess

💻 📖
Image
selmanfarukyilmaz

🐛
Image
donet5

🤔 🐛
Image
Zahlii

🐛
Image
salsasepp

🐛
Image
EmmettM

🐛 ⚠️
Image
robd003

🤔
Image
AllenEdison

🐛
Image
CSharpDummy

🐛
Image
shimondoodkin

🐛 🤔
Image
huuhait

🐛 🤔
Image
alexey-milovidov

🐛
Image
suconghou

🐛
Image
allegraharris

💻
Image
oliver-daniel

💻
Image
kerimsenturk5734

📖

This project adheres to the all-contributors specification. Contributions of any kind are welcome!