October 2025 Summaries

QuestDB, an open-source time-series database, is designed for high-demand workloads and offers features like ultra-low latency and high ingestion throughput. It supports Parquet and SQL, ensuring data portability and AI readiness without vendor lock-in. The author shares an experience debugging a race condition in a continuous integration (CI) build on Azure Pipelines, caused by a Bash script using the `set -x` option for command tracing. This resulted in a sporadic failure due to a phantom single quote added to a file path when stdout and stderr were processed simultaneously. The issue was traced back to a collision between Bash's xtrace feature and Azure Pipelines' log parser. By adjusting the script to disable tracing for a specific echo command, the problem was resolved, highlighting how complex systems can lead to unexpected behaviors and the importance of understanding interactions between different tools in a CI environment.

QuestDB is an open-source time-series database designed for high-performance workloads, such as trading floors and mission control, offering ultra-low latency and high ingestion throughput with a multi-tier storage engine. It supports Parquet and SQL, ensuring data portability and is geared for AI applications without vendor lock-in. The analysis of order book imbalance (OBI) is simplified with QuestDB's 9.0 release, which introduces N-dimensional array types to efficiently store and analyze order book data using NumPy-like arrays. This replaces the traditional need for multiple columns to store data at various price levels, allowing for more streamlined data representation and analysis with built-in array functions. In a tutorial using synthetic Bitcoin data, the setup of QuestDB with Grafana via Docker Compose is demonstrated for exploring market states, analyzing OBI under different scenarios, and visualizing data through heatmaps and timeseries charts. The tutorial highlights how QuestDB's capabilities facilitate complex order-book-imbalance analysis and visualization without the need for external tools, encouraging users to apply these methods to real-world data from sources like Coinbase or Binance.

QuestDB 9.1 is an open-source time-series database designed for high-demand workloads, offering ultra-low latency and high ingestion throughput with a multi-tier storage engine. The latest release introduces features like nanosecond timestamps, continuous profiling, auto-scaling symbol maps, and improved JOIN operations, enhancing precision, performance, and system visibility. The nanosecond precision is ideal for applications requiring high-frequency data tracking, while continuous profiling integrates the Async Profiler for easier performance analysis without external setup. Auto-scaling symbol maps address ingestion bottlenecks by dynamically adjusting capacity, and the JOIN improvements expand query capabilities, supporting all types and improving ASOF JOIN performance. Additional updates include new SQL functions, optimized list evaluations, and enhanced stability across the engine, making QuestDB one of the most complete and performant time-series databases for temporal analytics.