What is QuestDB?
QuestDB is an open-source time-series database engineered for demanding workloads, delivering ultra-low latency and high ingestion throughput. It features a multi-tier storage engine with native support for Parquet and SQL, ensuring data portability and AI readiness without vendor lock-in. The database is optimized for time-series data with capabilities like time-bucketing, streaming materialized views, and ASOF joins.
Built for scalability, QuestDB offers petabyte-scale tiered storage, multi-AZ resilience, and instant scale-out. It supports high-performance SQL queries with SIMD acceleration and multi-threaded execution, making it suitable for real-time analytics in industries like capital markets, digital assets, and IoT. The architecture includes write-ahead logging for durability, automatic data tiering to object storage, and seamless querying across hot and cold data tiers.
Features
- SIMD-Accelerated SQL Queries: Ultra-fast query performance using Single Instruction Multiple Data optimizations
- Multi-Tier Storage Engine: Automatic data tiering from hot ingest to cold storage in Parquet format
- Time-Series SQL Extensions: Native support for SAMPLE BY, ASOF JOIN, and streaming materialized views
- High Ingestion Throughput: Capable of ingesting millions of rows per second with write-ahead logging
- Open Format Compatibility: Native support for Parquet, Arrow, and Iceberg with no vendor lock-in
Use Cases
- Real-time trading data analysis and market surveillance
- IoT sensor data ingestion and monitoring
- Financial tick data processing and OHLC calculations
- Log analytics and time-series monitoring
- AI/ML data pipeline optimization with Parquet integration
FAQs
-
What is the difference between QuestDB Open Source and QuestDB Enterprise?
QuestDB Open Source is for evaluation, prototyping, and pilots with community support, while QuestDB Enterprise adds production-grade features like high availability, enterprise security, tiered storage, and SLA-backed support. -
What storage formats does QuestDB support?
QuestDB natively supports Apache Parquet, Arrow, and Iceberg formats, allowing querying across hot and cold storage tiers without vendor lock-in. -
How does QuestDB handle high availability?
QuestDB Enterprise provides replication, auto failover, and multi-AZ deployment with 99.9% uptime guarantee for mission-critical workloads.
