Skip to content

questdb/questdb

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
May 22, 2023 10:49
September 11, 2023 14:49
September 11, 2023 14:49
September 11, 2023 14:49
September 11, 2023 14:49
QuestDB Logo

ย 

QuestDB community Slack channel QuestDB open source contributors QuestDB on Apache Maven

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. It supports schema-agnostic ingestion using the InfluxDB line protocol, PostgreSQL wire protocol, and a REST API for bulk imports and exports.

QuestDB is well suited for financial market data, application metrics, sensor data, real-time analytics, dashboards, and infrastructure monitoring.

QuestDB implements ANSI SQL with native time-series SQL extensions. These SQL extensions make it simple to 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.

Try QuestDB

We provide a live demo provisioned with the latest QuestDB release and sample datasets:

  • Trips: 10 years of NYC taxi trips with 1.6 billion rows
  • Trades: live crypto market data with 30M+ rows per month
  • Pos: geolocations of 250k unique ships over time
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 questdb

questdb 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.

Connect to QuestDB

You can interact with QuestDB using the following interfaces:

Insert data

Below are our official questdb clients for popular programming languages:

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

Resources

๐Ÿ“š Read the docs

โ“ Get support

๐Ÿšข Deploy QuestDB

Contribute

We are always happy to have contributions to the project whether it is 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

๐Ÿ’ป ๐Ÿค” ๐Ÿ““

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 specification. Contributions of any kind are welcome!