ClickHouse® is a real-time analytics database management system

https://github.com/ClickHouse/ClickHouse

https://clickhouse.com/

https://clickhouse.com/docs/integrations/language-clients/python/sqlalchemy

ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real-time.

https://www.kdnuggets.com/a-beginners-guide-to-clickhouse-database

ClickHouse is an open-source column-oriented database management system that enables users to generate analytical reports using SQL queries in real-time. Designed for online analytical processing (OLAP), ClickHouse excels at handling large volumes of data, including streaming real-time data. Its columnar storage format allows for efficient data compression and fast query processing, making it particularly well-suited for data analytics.

 In addition to its open-source version, ClickHouse offers a managed service known as ClickHouse Cloud. The cloud simplifies operational overhead, reduces costs, and provides a serverless experience with features like autoscaling, tenant isolation, and security measures.

https://github.com/fanqingsong/clickhouse-analytics-demo

https://github.com/dmitry-lee/kafka-clickhouse-demo/tree/master

https://github.com/TheLastManSleeping/kafka-flink-clickhouse-demo

https://github.com/fanqingsong/superset-demo