QuestDB 10.1: fresher data, less I/O, and more analysis in SQL

QuestDB 10.1 is a feature-rich release for the open-source time-series database that targets lower latency, higher ingestion efficiency, and broader SQL-based analytics, while introducing more compatibility changes than a typical point release. Its opt-in merge-append partitions reduce disk rewriting for out-of-order data by appending merged partition slices and compacting them later, improving write amplification and data availability at the cost of temporary storage. New SQL capabilities include SUBSAMPLE for retaining representative real rows in charts, compression, and archives; exact discrete and continuous percentile functions with aggregate and window support; and the sys.metrics table, which stores internal metrics every second for database-native monitoring. The release also changes HORIZON JOIN behavior to preserve duplicate trade rows and correctly apply right-side predicates, accelerates GROUP BY operations over eligible joins through parallel execution, and allows list-valued DECLARE variables for filterable notebooks and dashboards. Additional improvements cover LATEST ON, indexed symbol pattern matching, time-zone sampling, large query memory use, lag and lead on symbols, WebSocket connectivity, and Web Console tools. Users are advised to review breaking changes before upgrading, particularly around HORIZON JOIN results, 32-bit INT arithmetic, interval syntax, timestamp behavior, reserved words, and platform support.

No tracked trend matches for this post yet.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.