QuestDB 6.2 January release, SQL JIT compiler

QuestDB version 6.2, an open-source time-series database, introduces significant enhancements aimed at improving performance and functionality for demanding workloads. Key updates include JDK 17 support and the introduction of a Just-in-Time (JIT) compiler for the SQL engine, which notably speeds up query execution involving arithmetic expressions. The update also enhances SQL and ILP capabilities, optimizes queries with LIMIT clauses, and reduces the ILP commit timeout to 1 second, facilitating faster data availability in SQL queries. The version addresses memory footprint concerns by improving query cache handling and offers new settings to manage memory usage efficiency, especially when interfacing with Grafana. Enhancements in the Web Console include table autocomplete, and improvements in ILP stability through fuzz testing have resolved critical edge cases. Network configuration has been streamlined for better usability, with backward compatibility maintained. Future updates promise features like UPDATE support and further refinements to JIT-compiled filters, as the QuestDB team actively seeks user feedback through community forums and GitHub.