ChDB, an in-memory OLAP SQL engine powered by ClickHouse, excels in several use cases such as real-time analytics, data warehousing, interactive dashboards, machine learning workflows, and embedded analytics. Its ability to process data quickly makes it ideal for applications requiring immediate insights, and it supports complex SQL queries for https://www.subwaybogocode.com dynamic data visualization. This makes ChDB a versatile tool for efficiently handling large datasets and providing in-process analytics.

ChDB seems super underrated. I wonder if there exists a way to use only CHDB in your client and only use S3 for storage.

I just noted that Clickhouse can read and WRITE to Avro, so might be possible store Avro on S3 and query via ChDB. Interesting.