QuestDB 9.0: Armed with Arrays

QuestDB 9.0 introduces significant enhancements to the open-source time-series database, focusing on performance and usability for demanding workloads. Key updates include the addition of N-dimensional arrays, which allow for efficient operations similar to NumPy arrays, and improvements in materialized views with new refresh modes that accommodate global time zones. Enhanced data deduplication mechanisms minimize I/O overhead, and the web console has been revamped for better user experience, including features like per-line query runners and a new query log. The ASOF JOIN feature now supports a TOLERANCE parameter for more precise time-series data matching. This release aims to bolster QuestDB's capabilities in high-throughput environments, with the promise of future updates such as full Parquet support and nanosecond timestamps.