Skip to main content
Join the official 2020 Python Developers SurveyStart the survey!

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')

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 sqlalchemy-clickhouse, version 0.1.5.post0
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy-clickhouse-0.1.5.post0.tar.gz (13.3 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page