dqlite-client

Async Python client for dqlite, Canonical's distributed SQLite. It connects to a dqlite cluster, finds the current Raft leader, runs SQL, and pools connections.

The API is inspired by asyncpg's ergonomics — explicit connect() / create_pool(), fetch / fetchall / fetchval, and context-manager transactions — with a deliberately simple data model: fetch returns list[dict], fetchall returns list[list], fetchval returns a scalar. There is no Record type.

Is this the package you want?

Use dqlite-client directly when you want a lightweight async client with no ORM or DB-API layer, or when you need fine-grained control over cluster bootstrapping and the wire protocol.

If you want a standard PEP 249 driver, SQLAlchemy, Alembic, or most ORMs, reach for a higher layer instead — see The dqlite Python stack below.

Installation

pip install dqlite-client

Requires Python 3.13+.

Usage

import asyncio
from dqliteclient import connect

async def main():
    conn = await connect("localhost:9001")
    async with conn.transaction():
        await conn.execute("CREATE TABLE IF NOT EXISTS t (id INTEGER PRIMARY KEY, name TEXT)")
        await conn.execute("INSERT INTO t (name) VALUES (?)", ["hello"])
        rows = await conn.fetch("SELECT * FROM t")   # list[dict]
        for row in rows:
            print(row)
    await conn.close()

asyncio.run(main())

Connection pool

from dqliteclient import create_pool

pool = await create_pool(["localhost:9001", "localhost:9002", "localhost:9003"])
async with pool.acquire() as conn:
    rows = await conn.fetch("SELECT 1")

The dqlite Python stack

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

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

For SQLAlchemy/ORM use, prefer sqlalchemy-dqlite or dqlite-dbapi.

Documentation

Architecture — layering, the connection lifecycle (a connection that loses its session is closed for good), transaction tracking, leader discovery and the pool.
Connection pooling — sizing, startup, and leader behavior.
Deployment: forking & multiprocessing — read this if you use gunicorn, Celery, or multiprocessing.
dqliteclient.sql — the lexical SQL helpers (comment stripping, top-level statement splitting) the client and the dbapi layer share.
Data types & NULL handling — the row model and a server-version gotcha for NULLs in typed columns.

Development

See DEVELOPMENT.md for setup and contribution guidelines.

License

MIT

Development Status
- 3 - Alpha
Framework
- AsyncIO
Intended Audience
- Developers
License
- OSI Approved :: MIT License
Operating System
- OS Independent
Programming Language
Topic
- Database
- Database :: Database Engines/Servers
Typing
- Typed

Download files

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

Source Distribution

dqlite_client-0.5.0.tar.gz (160.0 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.

dqlite_client-0.5.0-py3-none-any.whl (49.5 kB view details)

Uploaded Sep 13, 2026 Python 3

File details

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

File metadata

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

File hashes

Hashes for dqlite_client-0.5.0.tar.gz
Algorithm	Hash digest
SHA256	`d7ea2821660d06bf91e27eb50a9efabc5749960b0b2b393782cc2ed4b1520940`
MD5	`eca61b6bcad5efdc479288eb2b631432`
BLAKE2b-256	`e055ccf2712c63eecc47550b6b626cc3faf1cbde1963fde77b7f5ffee3bff8e7`

See more details on using hashes here.

Provenance

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

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

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: dqlite_client-0.5.0.tar.gz
- Subject digest: d7ea2821660d06bf91e27eb50a9efabc5749960b0b2b393782cc2ed4b1520940
- Sigstore transparency entry: 2820607731
- Sigstore integration time: Sep 13, 2026
Source repository:
- Permalink: letsdiscodev/python-dqlite-client@127154172d9704fd3debf1ff702c812ab48d395e
- 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@127154172d9704fd3debf1ff702c812ab48d395e
- Trigger Event: push