Skip to main content

ClickHouse SQLAlchemy Dialect

Project description

ClickHouse dialect for SQLAlchemy.

Installation

The package is installable through PIP:

pip install sqlalchemy-clickhouse

Usage

The DSN format is similar to that of regular Postgres:

>>> import sqlalchemy as sa
>>> sa.create_engine('clickhouse://username:password@hostname:port/database')
Engine('clickhouse://username:password@hostname:port/database')

For SSL add ssl parameter to URL:

>>> import sqlalchemy as sa
>>> sa.create_engine('clickhouse://username:password@hostname:port/database?ssl=True')
Engine('clickhouse://username:password@hostname:port/database')

It implements a dialect, so there’s no user-facing API.

Testing

The dialect can be registered on runtime if you don’t want to install it as:

from sqlalchemy.dialects import registry
registry.register("clickhouse", "base", "dialect")

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pupu-sqlalchemy-clickhouse, version 0.1.5
Filename, size File type Python version Upload date Hashes
Filename, size pupu-sqlalchemy-clickhouse-0.1.5.tar.gz (13.2 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page