CHDB

Summary from the TLDR Web Dev newsletter

chDB is an embedded SQL OLAP Engine that utilizes ClickHouse (a column-oriented database management system) for processing. It eliminates the requirement to separately install ClickHouse and minimizes data copying between C++ and Python using memoryview. chDB supports a wide range of input and output formats, including Parquet, CSV, JSON, Arrow, ORC, and more.