QuestDB System Properties

• Relational model with native time series support

• Column based storage and time partitioned

• Lazy data access through memory mapped files

• Repeatable read consistency

• Heavy parralelisation for both ingestion and queries

• Stream data in order of arrival
  

• Write complexity of O(1): constant performance irrespective of the dataset size
  

• Automatic on-the-fly time series out of order correction

• SIMD accelerated vectorized SQL queries

• Full SQL support, augmented for time-series

• Joins support: INNER, OUTER, CROSS, ASOF, SPICE, FULL

• Durable

• Interfaces: HTTP, REST API, InfluxDB Line Protocol, PostgreSQL Wire, Grafana

• Real-time data ingestion and istant SQL queries for time series

• High performance translates into reduced infrastructure costs

• APIs for read and writes: REST API, HTTP, InfluxDB Line Protocol, PostgreSQL Wire, Grafana

• Efficient disk storage

• Small footprint: 3MB executable
  

• Application metrics

• Financial market data and algo trading

• DevOps monitoring

• Real-time analytics

• IoT and sensor monitoring

• OLAP/analytical workloads

Apache 2.0.