aaiclick 0.0.8

A Python framework that translates Python code into ClickHouse operations for big data computing

aaiclick

A Python framework that translates Python code into ClickHouse operations for big data computing.

Overview

aaiclick converts Python computational logic into a flow of ClickHouse database operations, enabling execution of Python-equivalent computations at scale. The framework analyzes Python code and generates optimized ClickHouse queries that produce results equivalent to native Python execution, while leveraging ClickHouse's columnar storage and distributed processing capabilities for big data workloads.

Installation

The base install includes embedded chdb and SQLite — no external servers needed:

pip install aaiclick
python -m aaiclick setup

For a distributed deployment (remote ClickHouse server + PostgreSQL):

pip install "aaiclick[distributed]"

For AI features (lineage tracing, debug agents):

pip install "aaiclick[ai]"
# or everything:
pip install "aaiclick[all]"

Inspiration

• ClickHouse — data warehouse for storage and built-in operators; all computation runs as ClickHouse queries whenever possible
• Apache Spark — inspiration for custom operators when the data warehouse's built-in operators are not sufficient
• Airflow — enterprise-grade orchestration
• Pandas — API design inspiration
• SQLAlchemy — API design inspiration

License

MIT License - see LICENSE for details.