November 2021 Summaries

The ClickHouse team has released version 21.11, which includes several exciting new capabilities such as asynchronous inserts, interactive mode, UDFs, predefined connections, and compression gains. Asynchronous inserts allow for high rates of small inserts to be concurrently processed, reducing the need for large batches and improving performance. Local interactive mode enables users to run ClickHouse queries on local files without connecting to a server, making it ideal for ad-hoc use cases. Executable UDFs enable users to write custom functions in any programming language, while predefined connections simplify data source connections by allowing users to reference external data sources by name. Additionally, compression support has been added for importing and exporting data into ClickHouse. These new features aim to improve performance, user experience, and productivity for ClickHouse users.

ClickHouse recently hosted an online Meetup on October 19, 2021, where attendees discussed the latest features of the 21.10 version and upcoming roadmap changes. The event featured presentations by co-founder Alexey Milovidov and Sr. Software Engineer Maksim Kita, who introduced new User Defined Functions and table engines. Additionally, ClickHouse developers Vitaly Baranov and Artur Filatenkov discussed data encryption features, including full disk and column-level encryption. Key upcoming changes include the introduction of a C++ coordination system called ClickHouse Keeper, support for semi-structured data, and asynchronous insert mode. The event was attended by over 200 people in person and 3,853 viewers online, with a recording available on YouTube.