QuestDB 9.4.0: Posting index, cross-column fill, and smarter Web Console

QuestDB 9.4.0 introduces a range of enhancements designed to optimize time-series database performance, particularly for demanding workloads such as trading floors and mission control. This version features a new, more efficient index type for SYMBOL columns, which decreases index file size and increases lookup speed. The release also includes cross-column FILL(PREV) syntax to streamline data sampling processes and an improved Web Console that facilitates the creation of materialized views and offers context-aware SQL autocompletion. Additionally, QuestDB 9.4.0 brings new window functions and text visualization capabilities, as well as various performance improvements and bug fixes across SQL planning and execution. The update aims to provide users with faster data processing, enhanced query capabilities, and improved usability, making the platform more versatile and efficient for handling extensive datasets.