Documentation changelog
This page tracks significant updates to the QuestDB documentation.
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
Updated
- Window functions - Restructured into dedicated section with improved navigation, added EMA, VWEMA, and ksum() functions
- Views and materialized views - Comprehensive documentation overhaul with improved examples and clearer explanations
- Designated timestamp - Consolidated timestamp documentation with TICK syntax examples
- Enterprise backup - Improved documentation with clearer instructions
Reference
- Added
percent_rank()window function - Added
arg_min()andarg_max()aggregation functions - Added
length_bytes()function for byte-length of strings - Added
rnd_symbol_zipf()and weighted random generators - Added Euclidean and geographic geo functions
- Extended date arithmetic with sub-day units
December 2025
Releases
New
- Builtin profiler - Documentation for QuestDB's built-in query profiler
- WINDOW JOIN - SQL reference for window joins with time-based lookups
Updated
- Materialized views - Added
REFRESH PERIOD (SAMPLE BY INTERVAL)compact syntax documentation - Time-series optimizations - Improved explanations
Reference
- Added
weighted_avg(),weighted_stddev_rel(),weighted_stddev_freq()functions - Documented compact period syntax in SAMPLE BY
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
- Hetzner deployment - Step-by-step guide for deploying QuestDB on Hetzner Cloud
- DECIMAL datatype - Documentation for precise decimal arithmetic
- PGWire OIDC integration - Authentication via OpenID Connect
Updated
- Parquet export - Complete documentation for exporting data to Parquet format
- Shared pool configuration - Updated with network, query, and write shared pool options
- SQL hints - Rewritten section on temporal join hints
Reference
- Added
first()andlast()support for additional datatypes - Added
first_not_null()andlast_not_null()array support
October 2025
Releases
- 9.1.0 - Released October 3, 2025
New
- PGWire for C/C++ - Guide for C/C++ applications using PostgreSQL wire protocol
- Table and column naming rules - Guidelines for valid identifiers
Updated
- Architecture guide - Refreshed with current implementation details
- Nanoseconds - Added nanosecond timestamp precision documentation
TRUNCATE TABLE- AddedIF EXISTSclause
Reference
- Added
w(week) unit to SAMPLE BY reference
September 2025
Updated
- Partitioning - Improved formatting and explanations
- Go client examples - Updated to v4 API
August 2025
Releases
New
- Array functions - Documentation for array manipulation functions
Updated
to_timestamp()- Improved documentation with more examples- Web Console - Updated documentation for latest console features
July 2025
Releases
New
- N-dimensional arrays - Comprehensive guide to multi-dimensional arrays
- Order book analytics - Guide for processing order book data
- Period materialized views - Time-based refresh for materialized views
- ASOF JOIN TOLERANCE - Limit lookback window in temporal joins
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.