[GitHub] [superset] hodgesrm edited a comment on issue #13285: Superset Clickhouse driver

[GitBox <gi...@apache.org>]

hodgesrm edited a comment on issue #13285:
URL: https://github.com/apache/superset/issues/13285#issuecomment-785536382


   Adding to the original request by @suedschwede, I strongly recommend switching to clickhouse-sqlalchemy as the standard driver for ClickHouse. The reasons for this switch are as follows. 
   
   1. clickhouse-sqlalchemy is actively maintained (last commit 18 Feb 2021, under active development).
   2. Releases are pushed regularly to pypi.org (last push 14 Dec 2020).
   3. It has what appears to be a fairly complete SQLAlchemy implementation. 
   4. It supports both HTTP and native TCP wire protocols (vs. HTTP only)
   5. It has a good security including support for TLS, SNI, and configurable certificate verification (vs. no encryption support)
   6. It has a good suite of tests that check SQLAlchemy interfaces. 
   
   To the extent that there are compatibility issues like the one discussed here, we (Altinity) can get them fixed fairly quickly.  We currently recommend clickhouse-sqlalchemy and clickhouse-driver to our users and have made fixes to them in the past, most recently in December.
   
   What are the next steps to making this switch?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org