# QuestDB 9.0.0 Release **URL:** \ **Category:** Community\ **Tags:** announcement, release\ **Created:** [July 15, 2025, 3:26pm UTC](https://community.questdb.com/t/questdb-9-0-0-release/886 "2025-07-15T15:26:49Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\ **Post date:** [July 15, 2025, 3:26pm UTC](https://community.questdb.com/t/questdb-9-0-0-release/886/1 "2025-07-15T15:26:50Z")
We’re very pleased to announce the release of QuestDB 9.0.0, which brings with it a host of upgrades, including our new datatype - **N-dimensional arrays**. It is the most feature-rich and robust version of QuestDB so far, and there’s no better time to get started than right now! [Download it now](https://questdb.com/download/) and check out the [release post](https://questdb.com/blog/questdb-9-release/) for a more in-depth view! ![image](https://canada1.discourse-cdn.com/flex004/uploads/questdb/original/1X/fb3ffce88b5468f5c46c2323ef999c8a057947e7.png) Here are some highlights: - **N-dimensional arrays** - These are true multidimensional, NumPy-like arrays, supporting efficient slicing, transposing and sharing of arrays, without unecessary copying. - This initial release covers `DOUBLE[]`, with more types to follow soon! - **Binary line protocol** - A new `V2` version of the ILP client protocol has been released, which sends `DOUBLE` and `DOUBLE[]` values in binary format, ensuring efficient ingestion. - Its the first step our journey to make the clients smarter, and better integrated with key QuestDB features such as data deduplication, schema evolution, and replication failvoer. - **Materialized Views 2.0** - Three new refresh types - `MANUAL`, `TIMER`, `PERIOD`, covering many use cases: - `MANUAL` - for finer control over updates, and closer integration with your application. - `TIMER` - for straightforward CRON-like refreshes - `PERIOD` - for calendar-scheduled, timezone-aware refreshes, only including complete sample buckets. - **Faster data deduplication** - We’ve significantly sped up `DEDUP` when re-ingesting large amounts of identical data, avoiding unnecessary rewriting of partitions. - **ASOF JOIN with TOLERANCE** - `ASOF JOIN` has additional new syntax - `TOLERANCE` - which allows you to bound the time-range that will be allowed for a valid matching. - This complements our revised `ASOF JOIN` algorithm, which speeds up sparse-matching use cases by using a binary search. - **Web Console Revamp** - We’ve acted on popular feedback and added multi-line query execution, making manual test runs and data migrations far easier to manage. - There are now multiple run cursors for each query, and you can easily obtain a query plan for your query using a right-click! There are many more quality-of-life changes, performance improvements and bugfixes, so be sure to check out the [release notes](https://questdb.com/release-notes). Finally, we’d like to give a huge thanks to everyone who opened issues, pinged us on Slack, or shared production insights—your feedback powers QuestDB! ---
**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\ **Post date:** [July 15, 2025, 3:28pm UTC](https://community.questdb.com/t/questdb-9-0-0-release/886/2 "2025-07-15T15:28:33Z")
Closed on July 15, 2025, 3:28pm UTC ---
**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\ **Post date:** [July 15, 2025, 3:28pm UTC](https://community.questdb.com/t/questdb-9-0-0-release/886/3 "2025-07-15T15:28:42Z")
Pinned globally on July 15, 2025, 3:28pm UTC ---
**Author:** ![Anna\_Semenova](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/anna_semenova/32/486_2.png) [@Anna\_Semenova](https://community.questdb.com/u/Anna_Semenova)\ **Post date:** [October 8, 2025, 9:14am UTC](https://community.questdb.com/t/questdb-9-0-0-release/886/4 "2025-10-08T09:14:57Z")
Unpinned on October 8, 2025, 9:14am UTC