Python Clickhouse

Open-source Python projects categorized as Clickhouse

Top 11 Python Clickhouse Projects

  • sqlglot

    Python SQL Parser and Transpiler

  • Project mention: The Future of MySQL is PostgreSQL: an extension for the MySQL wire protocol | news.ycombinator.com | 2024-04-26

    This is probably referring to "zero changes to your driver code" and not "zero changes to the SQL you send over this driver".

    Translating between SQL dialects is notoriously hard and attempts to translate [1] are working in 95% of cases. But the last 5% would require 5x amount of work. That's because "SQL dialect" also includes weird edge cases of type inference of things like COALESCE(5, FALSE) and emulation of system catalogs (pg_catalog, information_schema).

    [1] https://github.com/tobymao/sqlglot

  • Scout Monitoring

    Free Django app performance insights with Scout Monitoring. Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.

    Scout Monitoring logo
  • ibis

    the portable Python dataframe library

  • Project mention: Show HN: SQLFrame – I ran PySpark without Spark on a SQL database | news.ycombinator.com | 2024-05-20
  • clickhouse-driver

    ClickHouse Python Driver with native interface support

  • jupysql

    Better SQL in Jupyter. 📊

  • Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | news.ycombinator.com | 2023-12-06

    Hey, HN community!

    We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!

    To get started, check out our tutorial: https://jupysql.ploomber.io/en/latest/quick-start.html

    SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.

    Here are some of JupySQL's main features:

    - Syntax highlighting

  • dbt-clickhouse

    The Clickhouse plugin for dbt (data build tool)

  • clickhouse-sink-connector

    Replicate data from MySQL, Postgres and MongoDB to ClickHouse

  • boxball

    Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • django-clickhouse

    This project's goal is to build Yandex ClickHouse database into Django project.

  • pgwarehouse

    Easily sync your Postgres database to a Snowflake, ClickHouse, or DuckDB warehouse.

  • dbcls

    DbCls is a versatile terminal client that supports various databases

  • Project mention: Show HN: DbCls is a versatile terminal client that supports various databases | news.ycombinator.com | 2023-08-28
  • csv2clickhouse

    Fast way to upload data from CSV files into ClickHouse. This script automates the process of creating database and tables in ClickHouse and uploading data from CSV files into those tables.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python Clickhouse discussion

Log in or Post with

Python Clickhouse related posts

  • Show HN: Hashquery, a Python library for defining reusable analysis

    1 project | news.ycombinator.com | 23 Apr 2024
  • Loading a trillion rows of weather data into TimescaleDB

    8 projects | news.ycombinator.com | 16 Apr 2024
  • This Week In Python

    5 projects | dev.to | 17 Mar 2024
  • Ibis: The portable Python dataframe library

    1 project | news.ycombinator.com | 13 Mar 2024
  • Pql, a pipelined query language that compiles to SQL (written in Go)

    6 projects | news.ycombinator.com | 28 Feb 2024
  • Ibis: The portable Python dataframe library

    1 project | news.ycombinator.com | 22 Feb 2024
  • Ibis – Universal Interface for Data Wrangling

    1 project | news.ycombinator.com | 13 Feb 2024
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 22 Jun 2024
    Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →

Index

What are some of the best open-source Clickhouse projects in Python? This list will help you:

Project Stars
1 sqlglot 5,882
2 ibis 4,445
3 clickhouse-driver 1,176
4 jupysql 651
5 dbt-clickhouse 225
6 clickhouse-sink-connector 191
7 boxball 111
8 django-clickhouse 103
9 pgwarehouse 65
10 dbcls 16
11 csv2clickhouse 4

Sponsored
Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com