ClickHouse Newsletter August 2022: Airlines are maybe not that bad

At ClickHouse, in-person meetups are back, although they can coincide with hot weather, and the company has a new webpage that's snazzier than the old one. The latest release of ClickHouse 22.7 includes several features such as positional arguments, deprecation of Ordinary Only database engine, support for expressions in window functions, two new join algorithms, and a MongoDB table function to query MongoDB from ClickHouse. Additionally, there are updates on performance, including the launch of ClickBench, a benchmark for analytical databases. The company is also highlighting its Query of the Month feature, where it analyzed airline flight delays and found that planes often catch up with their schedule over time. The newsletter includes reading suggestions and mentions new adopters of ClickHouse.