sqlalchemy-dqlite

A SQLAlchemy 2.0 dialect for dqlite, Canonical's distributed SQLite. Point SQLAlchemy (and Alembic, and most ORMs built on it) at a dqlite cluster with a dqlite:// URL and use it like any other backend.

It supports both the synchronous and the async SQLAlchemy engines, and builds on dqlite's SQLite roots, so SQLAlchemy treats it as a SQLite-family dialect.

Is this the package you want?

Yes, if you use SQLAlchemy or an ORM/migration tool on top of it (Alembic, Flask-SQLAlchemy, etc.) and want it backed by dqlite. If you want a plain database driver without SQLAlchemy, use dqlite-dbapi.

Installation

pip install sqlalchemy-dqlite

Requires Python 3.13+ and SQLAlchemy 2.0+.

Usage

from sqlalchemy import create_engine, text

engine = create_engine("dqlite://localhost:9001/mydb")
with engine.connect() as conn:
    print(conn.execute(text("SELECT 1")).fetchone())

Async:

from sqlalchemy.ext.asyncio import create_async_engine

engine = create_async_engine("dqlite+aio://localhost:9001/mydb")
async with engine.connect() as conn:
    result = await conn.execute(text("SELECT 1"))
    print(result.fetchone())

URL format: dqlite://host:port/database (or dqlite+aio://… for async). The host:port is the bootstrap node — the cluster is discovered from there. See Connection URL for details.

The dqlite Python stack

This is the top of four layered packages. Each builds on the one below:

Package	Role
sqlalchemy-dqlite — this package	SQLAlchemy 2.0 dialect
dqlite-dbapi	PEP 249 (DB-API 2.0) driver — sync & async
dqlite-client	Async wire client — pooling, leader discovery
dqlite-wire	Wire-protocol codec

Documentation

Transactions — SQLAlchemy owns BEGIN/COMMIT; no AUTOCOMMIT.
Connection URL — URL format, the bootstrap address, and query parameters.
Limitations & notes — STRICT tables, savepoint naming, and a server-version NULL gotcha.

Development

See DEVELOPMENT.md for setup, contribution guidelines, and how to run the SQLAlchemy compliance test suite.

License

MIT

Download files

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

Source Distribution

sqlalchemy_dqlite-0.5.0.tar.gz (233.4 kB view details)

Uploaded Sep 13, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

sqlalchemy_dqlite-0.5.0-py3-none-any.whl (48.7 kB view details)

Uploaded Sep 13, 2026 Python 3

File details

Details for the file sqlalchemy_dqlite-0.5.0.tar.gz.

File metadata

Download URL: sqlalchemy_dqlite-0.5.0.tar.gz
Upload date: Sep 13, 2026
Size: 233.4 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for sqlalchemy_dqlite-0.5.0.tar.gz
Algorithm	Hash digest
SHA256	`61ea183967c46fef863772de7fad43287eb7a8f4b3ec3a4ff30df6c490ac4965`
MD5	`4b7c9c7e4d7bdfd2ef78018fdf4820a4`
BLAKE2b-256	`0ab75159e08a72b607abb43f57bddadc48e7992fabfc7b2def0917cc829ddace`

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlalchemy_dqlite-0.5.0.tar.gz:

Publisher: publish-to-pypi.yml on letsdiscodev/sqlalchemy-dqlite

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: sqlalchemy_dqlite-0.5.0.tar.gz
- Subject digest: 61ea183967c46fef863772de7fad43287eb7a8f4b3ec3a4ff30df6c490ac4965
- Sigstore transparency entry: 2820607891
- Sigstore integration time: Sep 13, 2026
Source repository:
- Permalink: letsdiscodev/sqlalchemy-dqlite@f84b914805a097cbe87cf1661538b3d7fad31fe2
- Branch / Tag: refs/tags/v0.5.0
- Owner: https://github.com/letsdiscodev
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish-to-pypi.yml@f84b914805a097cbe87cf1661538b3d7fad31fe2
- Trigger Event: push