QuestDB 9.4.2: shareable queries, new aggregates, and a hardening pass
Blog post from QuestDB
QuestDB 9.4.2 is an open-source time-series database optimized for demanding workloads that emphasizes ultra-low latency, high ingestion throughput, and a multi-tier storage engine, with native support for Parquet and SQL to ensure data portability and AI readiness. The release is primarily focused on hardening efforts through fuzz testing and stricter query-result assertions, addressing edge cases related to Parquet tables and new posting indexes, and includes improvements from version 9.4.1 such as new aggregate functions, DECIMAL window functions, and enhanced materialized view refresh speeds. The Web Console has been updated to allow the sharing of queries via runnable links, facilitating collaboration without the need for SQL copy-pasting, while also enhancing the visibility of storage policy settings and refining query validation. The update introduces two new aggregate functions, array_agg() and regr_r2(), which are useful for grouping values and assessing linear regression trends, respectively, and expands window function support to all DECIMAL sub-types. Additionally, the release addresses several bug fixes and introduces breaking changes such as modifications to index types and commands related to views, making this release a comprehensive enhancement to the database's functionality and robustness.