DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

QuestDB


QuestDB is an open-source SQL database designed to process time-series data, faster.

Source Code
https://github.com/questdb/questdb[02]
Developer
Country of Origin
GB
Start Year
2014 [04]
Former Name
nfsdb
Project Types
Commercial, Open Source
Written in
C++, Java
Supported Languages
C, C++, Go, Java, JavaScript, Python, R, Rust, SQL
Inspired By
Kdb+
Compatible With
InfluxDB, PostgreSQL
Operating Systems
Android, Linux, macOS, Windows
License
Apache v2

It uses a column-oriented approach, vectorized execution, SIMD instructions, and a whole array of low-latency techniques. The whole code base is built from scratch and without dependencies, in the name of performance. QuestDB is 100% free from garbage collection.

QuestDB implements SQL, and augments it for time-series. It exposes a Postgres wire protocol, a high-performance REST API, and even supports ingestion with InfluxDB line protocol. It supports both relational and time-series joins, which makes it easy to correlate data over time. Writes are durably committed to disk, meaning that the data is safe - yet instantly accessible.

Database Entry

QuestDB


QuestDB is an open-source SQL database designed to process time-series data, faster.

It uses a column-oriented approach, vectorized execution, SIMD instructions, and a whole array of low-latency techniques. The whole code base is built from scratch and without dependencies, in the name of performance. QuestDB is 100% free from garbage collection.

QuestDB implements SQL, and augments it for time-series. It exposes a Postgres wire protocol, a high-performance REST API, and even supports ingestion with InfluxDB line protocol. It supports both relational and time-series joins, which makes it easy to correlate data over time. Writes are durably committed to disk, meaning that the data is safe - yet instantly accessible.

History[04]


QuestDB was born as a side project from Vlad Ilyushchenko who applied principles from low latency techniques found in the financial services industry. Its recent Hacker News launch goes through the story of QuestDB from 2013.

Data Model


Relational model, optimised for time-series

Citations

4 sources
  1. QuestDB | Low-latency time-series database on open formats questdb.io
  2. GitHub - questdb/questdb: QuestDB is a high performance, open-source, time-series database · GitHub github.com
  3. QuestDB Documentation - SQL Time-Series Database Guides | QuestDB questdb.com
  4. Initial commit github.com
Revision #8