search

chdb-io / chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
https://clickhouse.com/docs/en/chdb
Apache License 2.0
2.03k stars 72 forks source link

Intergrate with jupysql #15

Closed auxten closed 1 year ago

auxten commented 1 year ago

Something like https://jupysql.ploomber.io/en/latest/integrations/duckdb.html chdb needs a Python DB API 2.0 wrapper to run with jupysql.

idomic commented 1 year ago

If that works well, we can add a guide to our docs as well! We do have integration with click house so I assume it'll be pretty straight forward!

edublancas commented 1 year ago

@auxten: can chdb use the clickhouse sqlalchemy driver? If so, it should work without changes: https://jupysql.ploomber.io/en/latest/integrations/clickhouse.html

if that doesn't work, we're working on adding support for any driver that follows the DB 2.0 spec

auxten commented 1 year ago

Thank you @idomic I need to dive into duckdb and clickhouse-connect to see how to do that @edublancas

auxten commented 1 year ago

It seems @laodouya is working on the Python DB API 2.0 #30

edublancas commented 1 year ago

great! we added support for DB API 2.0 in Jupysql 0.7.2

lmangani commented 1 year ago

great! we added support for DB API 2.0 in Jupysql 0.7.2

If you want you can test the changes ahead or release and provide any feedback: https://github.com/chdb-io/chdb/pull/30