adbc-poolhouse

Connection pooling for ADBC drivers from typed warehouse configs.

One config in, one pool out — create_pool(SnowflakeConfig(...)) returns a ready-to-use SQLAlchemy QueuePool.

Installation

pip install adbc-poolhouse

Driver extras are available for each supported warehouse (BigQuery, DuckDB, FlightSQL, PostgreSQL, Snowflake, SQLite). See the documentation for the full list.

Quick example

The example below uses DuckDB — no credentials or running server required.

from adbc_poolhouse import DuckDBConfig, create_pool, close_pool

# File-backed database (connections share the same file)
config = DuckDBConfig(database="/tmp/warehouse.db")
pool = create_pool(config)

with pool.connect() as conn:
    cursor = conn.cursor()
    cursor.execute("SELECT 42 AS answer")
    row = cursor.fetchone()
    print(row)  # (42,)

close_pool(pool)

pool.connect() checks out a connection from the pool and returns it when the with block exits. close_pool(pool) drains the pool and closes the underlying ADBC source connection.

Supported warehouses

PyPI drivers: BigQuery, DuckDB, FlightSQL, PostgreSQL, Snowflake, SQLite

Foundry-distributed drivers: ClickHouse, Databricks, MSSQL / Azure SQL / Fabric, MySQL, Redshift, Trino

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

adbc_poolhouse-1.6.2.tar.gz (66.2 kB view details)

Uploaded Aug 3, 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.

adbc_poolhouse-1.6.2-py3-none-any.whl (86.4 kB view details)

Uploaded Aug 3, 2026 Python 3

File details

Details for the file adbc_poolhouse-1.6.2.tar.gz.

File metadata

Download URL: adbc_poolhouse-1.6.2.tar.gz
Upload date: Aug 3, 2026
Size: 66.2 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for adbc_poolhouse-1.6.2.tar.gz
Algorithm	Hash digest
SHA256	`cd362e71abfb318af74a17bfa72e31a1186a6387cddfd2f8cbb2331bdbe39a89`
MD5	`b1399ca06904fceedf6d604f2fb25c22`
BLAKE2b-256	`5e3673ade550ed31d7cf3c19fec721243ad52993e8a40c3499648b4304953953`

See more details on using hashes here.

Provenance

The following attestation bundles were made for adbc_poolhouse-1.6.2.tar.gz:

Publisher: release.yml on anentropic/adbc-poolhouse

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: adbc_poolhouse-1.6.2.tar.gz
- Subject digest: cd362e71abfb318af74a17bfa72e31a1186a6387cddfd2f8cbb2331bdbe39a89
- Sigstore transparency entry: 2335639229
- Sigstore integration time: Aug 3, 2026
Source repository:
- Permalink: anentropic/adbc-poolhouse@802ab7254dd492661e794ad261fc247f6512d07e
- Branch / Tag: refs/tags/v1.6.2
- Owner: https://github.com/anentropic
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: release.yml@802ab7254dd492661e794ad261fc247f6512d07e
- Trigger Event: push