Home / Companies / QuestDB / Blog / Post Details
Content Deep Dive

QuestDB 9.3.5 and QuestDB Enterprise 3.2.5: Lateral Joins, UNNEST, and Statistical Window Functions

Blog post from QuestDB

Post Details
Company
Date Published
Author
Javier Ramirez
Word Count
1,912
Company Posts That Month
4
Language
English
Hacker News Points
-
Post removed?
No
Summary

QuestDB is an open-source time-series database designed for high-demand environments, offering ultra-low latency and high ingestion throughput. The latest updates, QuestDB 9.3.5 and QuestDB Enterprise 3.2.5, introduce features such as lateral joins for dynamic filtering and top-N per group patterns, UNNEST for expanding arrays and JSON into rows, and new statistical window functions for detailed risk analytics. Enhancements include support for multi-table HORIZON JOIN, bloom filter configuration for optimized data retrieval, and performance improvements in hash joins and query execution. These updates aim to make data processing more efficient, portable, and AI-ready, while reducing vendor lock-in. The release also addresses various bug fixes and introduces breaking changes in timezone handling for SAMPLE BY queries, urging users to review documentation for potential impacts. QuestDB Enterprise customers benefit from additional fixes and support, with options for self-managed and BYOC configurations.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

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.