ClickHouse/ClickHouse
ClickHouse is an open-source, column-oriented database management system designed for real-time analytics and high-performance data processing.
Awesome ClickHouse › ClickHouse and derivatives
chdb-io/chdb
chDB is an in-process OLAP SQL engine powered by ClickHouse, designed to provide fast and efficient analytical processing without the need to install ClickHouse separately. It supports a wide range of data formats including Parquet, CSV, JSON, Arrow, ORC, and over 60 additional formats, enabling versatile data input and output. The engine minimizes data copying between C++ and Python using python memoryview, enhancing performance. chDB supports Python DB API 2.0, allowing seamless integration with Python applications. It offers multiple ways to query data, including connection-based API, querying on files, tables, and Pandas DataFrames, and supports stateful sessions for temporary database, table, and view creation with automatic cleanup. Users can also define User Defined Functions (UDFs) in Python to extend query capabilities. The project supports querying on various data sources such as on-disk files and in-memory data structures, and provides output in multiple formats including pretty print, JSON, CSV, and Pandas DataFrame. It is compatible with Python 3.8+ on macOS and Linux for both x86_64 and ARM64 architectures. chDB is part of the ClickHouse family and aims to bring the power of ClickHouse's OLAP capabilities directly into Python environments with minimal setup and high efficiency. The project includes comprehensive examples and tests to demonstrate its features and usage scenarios, making it accessible for developers looking to perform OLAP queries within Python applications efficiently.
https://github.com/chdb-io/chdb
Also in ClickHouse and derivatives
timeplus-io/proton
Timeplus Proton is a high-performance, lightweight streaming SQL engine powered by ClickHouse, designed for real-time analytics and ETL on streaming data from Kafka, Pulsar, Iceberg, and ClickHouse with advanced features like CDC, UPSERT, and multi-stream JOINs.
ByConity/ByConity
ByConity is an open-source cloud data warehouse derived from ClickHouse, designed with a cloud-native architecture to provide high-performance querying and unified management of batch and streaming data at large scale.
myscale/MyScaleDB
MyScaleDB is a high-performance SQL vector database built on ClickHouse, enabling scalable AI applications with advanced vector and full-text search capabilities using familiar SQL.