An open-source time-series database for high-speed ingestion and low-latency SQL queries.
QuestDB is an open-source time-series database optimized for high-speed data ingestion and low-latency SQL queries. It solves the problem of efficiently storing and querying massive volumes of time-stamped data, such as financial market ticks or sensor telemetry, with specialized extensions for time-series analysis.
Developers and data engineers building real-time analytics, monitoring systems, or financial applications that require handling high-throughput time-series data with low-latency queries.
Developers choose QuestDB for its exceptional ingestion performance, SQL-native interface with time-series extensions, and open-source flexibility without vendor lock-in, outperforming alternatives in benchmarks for time-series workloads.
QuestDB is a high performance, open-source, time-series database
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Handles millions of events per second with low latency, as evidenced by benchmarks showing higher throughput than InfluxDB and TimescaleDB.
Includes specialized functions like ASOF JOIN, WINDOW JOIN, and SAMPLE BY for efficient time-based analytics, directly addressing time-series challenges.
Utilizes SIMD instructions and parallelized vector execution for optimized query performance, leveraging modern CPU architectures.
Offers a storage engine from WAL to columnar to Parquet on object storage, enabling cost-effective data lifecycle management and cold storage integration.
Critical production features like high availability, role-based access control, and TLS encryption are only available in the paid QuestDB Enterprise version.
As a time-series database, it lacks support for non-time-series workloads like document queries or complex geospatial operations, limiting general-purpose use.
The README emphasizes capacity planning for production, indicating that optimal performance requires careful configuration and tuning, which can be non-trivial.
QuestDB is an open-source alternative to the following products:
InfluxDB is an open-source time series database designed for handling high write and query loads, commonly used for monitoring metrics and events.
TimescaleDB is an open-source time-series database built on PostgreSQL, optimized for fast ingestion and complex queries of time-stamped data.
Kdb+ is a high-performance columnar database and time-series analytics platform used in financial services and other data-intensive applications.