Company
Date Published
Author
Alexey Milovidov
Word count
1927
Language
English
Hacker News points
None

Summary

The new ClickHouse release 22.3 offers a long-term support release with security updates and important bug fixes through March 2023, featuring 1308 new commits from 86 contributors. The changes are primarily focused on feature maturity, security, and reliability, with several experimental features becoming ready for production usage, including ClickHouse Keeper as a replacement for ZooKeeper. Additionally, ClickHouse now supports the ARM architecture, with continuous integration and testing passing for AArch64 models, enabling faster performance on this architecture. Virtual Filesystem Over S3 is also available in preview, allowing for more efficient data storage and querying. The release includes various security features, such as authentication with X.509 client certificates, improved fuzzing and testing, and semistructured data support. Performance improvements include optimizations for insertion into MergeTree tables and SELECT queries with huge lists in WHERE IN clauses. Local Cache For Remote Filesystem is also available, providing significant performance enhancements when reading from remote filesystems. Overall, ClickHouse 22.3 aims to provide a more secure, reliable, and efficient database solution.