QuestDB 9.0.0 Release

Community
,
1

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 and check out the release post for a more in-depth view!

image
image2944×1466 551 KB

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.

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!