A database driver (DBAPI layer) is required to work with this dialect.

For psycopg2 support you must install either:

• psycopg2, which has some prerequisites of its own, or

• psycopg2-binary

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

For asyncpg support you must install

• asyncpg

For more details on working with asyncpg, see README.asyncpg.md

For psycopg version 3 support, you'll need to install

• psycopg

As with psycopg2, psycopg can be installed as binary for development and testing purposes. (Installing as binary avoids the need for the libpq-dev package to be installed first.)

pip install psycopg[binary]

For more details on working with psycopg, see README.psycopg.md

Use pip to install the latest release for this version of the dialect.

pip install "sqlalchemy-cockroachdb~=2.0"

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

pip install "sqlalchemy-cockroachdb<2.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:

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

To connect using psycopg for sync operation:

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

To connect using psycopg for async operation, see README.psycopg.md

See CHANGES.md