Documentation changelog

This page tracks significant updates to the QuestDB documentation.

May 2026​

New​

Reference​

  • Fixed timestamp_ns valid range documentation
  • Added precise microsecond-grained timestamp examples for PHP clients
  • Fixed PIVOT syntax: removed redundant FOR from multiple pivot statements
  • Updated Python client to use sender.new_buffer() for buffer initialization

Updated​

  • Aggregation functions - Added demo tags and updated examples with runnable queries
  • LATEST ON - Added demo tags to examples
  • JOIN - Updated examples to use demo data
  • GROUP BY - Replaced examples with fx_trades demo queries
  • DISTINCT - Replaced examples with fx_trades demo queries
  • CAST - Added demo tags to examples
  • PIVOT - Fixed examples to use demo server data
  • Array functions - Improved page with demo examples
  • TICK syntax - Documented imprecise date support
  • Configuration reference - Revamped into 17 dedicated per-subsystem pages with epigraph-style property listings

April 2026​

Releases​

  • 9.3.5 - Released April 13, 2026

New​

Reference​

  • Added Parquet bloom filters syntax and configuration
  • Added covar_samp(), corr(), and other statistical window functions
  • Added array_elem_min(), array_elem_max(), array_elem_sum(), array_elem_avg() to array functions
  • Fixed alphabetical ordering and added missing functions across reference pages
  • Added Azure ReadWrite disk caching warning to deployment docs

Updated​

  • SQL reference pages - Replaced railroad diagrams with code-based syntax blocks across 65 SQL pages, with updated examples
  • SAMPLE BY - Updated timezone bucket alignment behavior
  • Parquet export - Added partitioning options for exports
  • WINDOW JOIN - Documented dynamic window boundaries
  • HORIZON JOIN - Documented multi-RHS table support
  • JOIN - Improved join documentation and reorganized page
  • Web Console - Added table details, updated screenshots
  • TTL - Fixed removal syntax and general improvements
  • REST API /exp endpoint - Documented timeout parameter, removed outdated warning

March 2026​

Releases​

  • 9.3.4 - Released March 26, 2026

New​

Reference​

Updated​

February 2026​

Releases​

  • 9.3.3 - Released February 25, 2026

New​

  • HORIZON JOIN - Full reference page for post-trade analysis joins
  • Post-trade analysis recipes: markout, slippage, implementation shortfall, ECN scorecard, last-look, and VPIN
  • Financial indicator recipes: RSI, MACD, Stochastic, Rate of Change, ATR, Donchian Channels, Keltner Channels, Realized Volatility, OBV, Maximum Drawdown, Bid-Ask Spread
  • TICK Exchange Calendars - Enterprise feature for market-hours-aware time intervals
  • AI Coding Agents - Renamed from LLM Coding Assistants, added QuestDB agent skill documentation

Reference​

  • Added twap() aggregate function
  • Added array_build() function
  • Documented count(distinct) syntax
  • Updated Java ILP client artifact
  • Added WAL cleaner documentation for replication

Updated​

January 2026​

Releases​

  • 9.3.2 - Released January 28, 2026
  • 9.3.1 - Released January 14, 2026
  • 9.3.0 - Released January 9, 2026

New​

  • Cookbook - Collection of 40+ recipes for common SQL patterns, integrations, and operations
  • Capital markets recipes - Financial calculations including VWAP, Bollinger Bands, TICK/TRIN, volume analysis, and more
  • TICK syntax - New DSL for expressing time intervals with intuitive syntax like '$now - 1h..$now'
  • AI Assistant reference - Documentation for the QuestDB AI Assistant
  • PIVOT - SQL keyword for rotating rows into columns

Reference​

Updated​

December 2025​

Releases​

  • 9.2.3 - Released December 18, 2025
  • 9.2.2 - Released December 1, 2025

New​

  • Builtin profiler - Documentation for QuestDB's built-in query profiler
  • WINDOW JOIN - SQL reference for window joins with time-based lookups

Reference​

Updated​

November 2025​

Releases​

  • 9.2.1 - Released November 25, 2025
  • 9.2.0 - Released November 13, 2025
  • 9.1.1 - Released November 3, 2025

New​

Reference​

  • Added first() and last() support for additional datatypes
  • Added first_not_null() and last_not_null() array support

Updated​

October 2025​

Releases​

  • 9.1.0 - Released October 3, 2025

New​

Reference​

Updated​

September 2025​

Updated​

August 2025​

Releases​

  • 9.0.3 - Released August 29, 2025
  • 9.0.2 - Released August 15, 2025

New​

Updated​

July 2025​

Releases​

  • 9.0.1 - Released July 23, 2025
  • 9.0.0 - Released July 11, 2025

New​

Updated​

  • ILP clients - Array support added to Python, C++, Rust, Java, and .NET clients
  • WAL metrics - Added metrics for detecting WAL apply lag

Earlier updates​

For documentation changes before July 2025, see the git commit history.