QuestDB
What is QuestDB?
QuestDB is an open-source relational time series database (database / data infrastructure) designed for high-throughput ingestion and Structured Query Language (SQL) analytics over time-stamped data.
- Column-oriented time series database for relational and time-based workloads (database)
- SQL support with PostgreSQL wire protocol compatibility for queries and integrations (data access / interoperability)
- High-throughput ingestion of time series data via InfluxDB line protocol, Representational State Transfer (REST), and other interfaces (data ingestion)
- Single-node and container-based deployment options for on-premises (on-prem) and cloud environments (deployment / infrastructure)
- Focus on low-latency querying for monitoring, Internet of Things (IoT), financial, and telemetry data (analytics / observability)
Show more
More About QuestDB
QuestDB is an open-source time series relational database (database / data infrastructure) purpose-built for workloads that generate large volumes of time-stamped data, such as observability, financial market data, IoT, and application telemetry. It uses a column-oriented storage model and time series–aware design to support high ingestion rates and low-latency queries over recent and historical data using standard SQL syntax.
The database exposes a relational model with tables and columns while optimizing for time as a primary dimension (time series database). QuestDB stores data in a columnar format, which is suited for analytical scans and aggregations over large datasets. It provides SQL as its main query language (data access), and supports features such as filtering, aggregations, and joins on time series and relational attributes. This allows engineers and analysts to work with time series data using familiar relational constructs.
QuestDB includes multiple ingestion mechanisms (data ingestion). It supports the InfluxDB line protocol, which enables direct integration with existing metrics and telemetry pipelines that already emit this format. It also provides HTTP/REST and other interfaces for batch or streaming inserts. These ingestion paths are designed to accept high event volumes while maintaining query performance.
For interoperability with existing tools and drivers, QuestDB implements the PostgreSQL wire protocol (interoperability / connectivity). This allows many PostgreSQL-compatible clients, BI tools, and libraries to connect to QuestDB as if it were a PostgreSQL endpoint, without custom drivers. The database can be deployed as a single binary, in containers such as Docker, or integrated into orchestration platforms, supporting on-prem and cloud environments (deployment / infrastructure).
In enterprise and institutional environments, QuestDB is used to store and query operational metrics, trading and market data, sensor and device streams, and application logs (observability / analytics). Its time series focus supports queries over event timelines, downsampling, and retention patterns common in monitoring, financial analytics, and industrial telemetry. The project positions itself in the directory as an open-source time series database with SQL and PostgreSQL protocol compatibility, columnar storage, and high-throughput ingestion capabilities intended for analytical and operational workloads on time-ordered data.