QuestDB is a high performance open source SQL database for time series data.
- Website
- https://questdb.com/[01]
- Source Code
- https://github.com/questdb/questdb[02]
- Tech Docs
- https://questdb.com/docs/[03]
- Developer
- Country of Origin
- GB
- Start Year
- 2013 [04]
- Project Types
- Commercial, Open Source
- Inspired By
- Kdb+
- Compatible With
- InfluxDB, PostgreSQL
- License
- Apache v2
It uses a column-oriented approach, heavy parallelized vectorized execution, SIMD instructions and a whole array of low-latency techniques. The whole code base is built from scratch, without dependencies and 100% free from garbage collection.
QuestDB implements SQL and augments it for time-series with native extensions. It exposes a Postgres wire protocol, high-performance REST API and supports ingestion with InfluxDB Line Protocol. QuestDB uses a relational model and can be both shema or schema-free through InfluxDB Line Protocol. Relational and time-series joins make it easy to correlate data over time. Writes are durably committed to disk, meaning that the data is safe - yet instantly accessible.
QuestDB is a high performance open source SQL database for time series data.
It uses a column-oriented approach, heavy parallelized vectorized execution, SIMD instructions and a whole array of low-latency techniques. The whole code base is built from scratch, without dependencies and 100% free from garbage collection.
QuestDB implements SQL and augments it for time-series with native extensions. It exposes a Postgres wire protocol, high-performance REST API and supports ingestion with InfluxDB Line Protocol. QuestDB uses a relational model and can be both shema or schema-free through InfluxDB Line Protocol. Relational and time-series joins make it easy to correlate data over time. Writes are durably committed to disk, meaning that the data is safe - yet instantly accessible.
History[04][05]
QuestDB started as a side project in 2013 by Vlad Ilyushchenko who applied principles from low latency techniques found in the financial services industry. QuestDB is backed by YCombinator.
Concurrency Control[06]
QuestDB uses a single writer model. The writer re-orders timestamps on the fly. Multi-publisher, single consumer queue provides concurrent write access.
Indexes[08]
Indexing is available for symbol columns. Index support for other types will be added over time.
Joins[09]
QuestDB supports the following types of joins: INNER, OUTER, CROSS, ASOF and SPLICE. FULL joins are not yet implemented and are on our roadmap. All supported join types can be combined in a single SQL statement.
Query Interface[11]
QuestDB enhances ANSI SQL with time series extensions to manipulate time stamped data.
Storage Model[07]
QuestDB uses a column-based storage model. Data is stored in tables with each column stored in its own file and its own native format. New data is appended to the bottom of each column to allow data to be organically retrieved in the same order that it was ingested.
Citations
12 sources- QuestDB | Low-latency time-series database on open formats questdb.com
- GitHub - questdb/questdb: QuestDB is a high performance, open-source, time-series database · GitHub github.com
- QuestDB Documentation - SQL Time-Series Database Guides | QuestDB questdb.com
- Initial commit github.com
- Launch HN: QuestDB (YC S20) – Fast open source time series database | Hacker News ycombinator.com
- Architecture Overview | QuestDB questdb.com
- Architecture Overview | QuestDB questdb.com
- Indexes | QuestDB questdb.com
- JOIN keyword | QuestDB questdb.com
- Aggregating billions of rows per second with SIMD | QuestDB questdb.com
- https://questdb.com/docs/concept/sql-execution-order questdb.com
- Architecture Overview | QuestDB questdb.com