SaaSHub helps you find the best software and product alternatives Learn more →
Top 11 Python Clickhouse Projects
-
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.
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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.
Project mention: The Future of MySQL is PostgreSQL: an extension for the MySQL wire protocol | news.ycombinator.com | 2024-04-26This 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
Project mention: Show HN: Hashquery, a Python library for defining reusable analysis | news.ycombinator.com | 2024-04-23I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]
0: https://ibis-project.org/
Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | news.ycombinator.com | 2023-12-06Hey, 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
Project mention: Show HN: DbCls is a versatile terminal client that supports various databases | news.ycombinator.com | 2023-08-28
Python Clickhouse related posts
-
Show HN: Hashquery, a Python library for defining reusable analysis
-
Loading a trillion rows of weather data into TimescaleDB
-
This Week In Python
-
Ibis: The portable Python dataframe library
-
Pql, a pipelined query language that compiles to SQL (written in Go)
-
Ibis: The portable Python dataframe library
-
Ibis – Universal Interface for Data Wrangling
-
A note from our sponsor - SaaSHub
www.saashub.com | 10 May 2024
Index
What are some of the best open-source Clickhouse projects in Python? This list will help you:
Project | Stars | |
---|---|---|
1 | sqlglot | 5,573 |
2 | ibis | 4,241 |
3 | clickhouse-driver | 1,167 |
4 | jupysql | 610 |
5 | dbt-clickhouse | 214 |
6 | clickhouse-sink-connector | 177 |
7 | boxball | 110 |
8 | django-clickhouse | 104 |
9 | pgwarehouse | 60 |
10 | dbcls | 16 |
11 | csv2clickhouse | 4 |
Sponsored