Project: sqlalchemy-cockroachdb

CockroachDB dialect for SQLAlchemy

Project Details

Latest version
2.0.1
Home Page
https://github.com/cockroachdb/sqlalchemy-cockroachdb
PyPI Page
https://pypi.org/project/sqlalchemy-cockroachdb/

Project Popularity

PageRank
0.001616443695893125
Number of downloads
230715

CockroachDB dialect for SQLAlchemy

Prerequisites

For psycopg2 support you must install either:

(The binary package is a practical choice for development and testing but in production it is advised to use the package built from sources.)

Or, for asyncpg support (⚠️ experimental 🏗) you must install

Install and usage

Use pip to install the latest version.

pip install sqlalchemy-cockroachdb

NOTE: This version of the dialect requires SQLAlchemy 2.0 or later. To work with earlier versions of SQLAlchemy you'll need to install an earlier version of this dialect.

pip install sqlalchemy-cockroachdb<2.0.0

Use a cockroachdb connection string when creating the Engine. For example, to connect to an insecure, local CockroachDB cluster using psycopg2:

from sqlalchemy import create_engine
engine = create_engine('cockroachdb://root@localhost:26257/defaultdb?sslmode=disable')

or

from sqlalchemy import create_engine
engine = create_engine('cockroachdb+psycopg2://root@localhost:26257/defaultdb?sslmode=disable')

To connect using asyncpg (⚠️ experimental 🏗):

from sqlalchemy import create_async_engine
engine = create_async_engine('cockroachdb+asyncpg://root@localhost:26257/defaultdb')

Changelog

See CHANGES.md