adbc-poolhouse
[ Docs ]
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
Links
License
MIT
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file adbc_poolhouse-1.5.1.tar.gz.
File metadata
- Download URL: adbc_poolhouse-1.5.1.tar.gz
- Upload date:
- Size: 54.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
42062a75eecb850b64bf668729cbbcd594df9034070e42d88e168f7dad4fe748
|
|
| MD5 |
54a4e6476d4dbb675ece9fd9bbd2f36e
|
|
| BLAKE2b-256 |
633c1d2453d37a4395c89c43965677ae212c243e6b0df039d9549321ff0ec9dd
|
Provenance
The following attestation bundles were made for adbc_poolhouse-1.5.1.tar.gz:
Publisher:
release.yml on anentropic/adbc-poolhouse
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
adbc_poolhouse-1.5.1.tar.gz -
Subject digest:
42062a75eecb850b64bf668729cbbcd594df9034070e42d88e168f7dad4fe748 - Sigstore transparency entry: 2099090087
- Sigstore integration time:
-
Permalink:
anentropic/adbc-poolhouse@2b3580e8d5b8c8f295887d59eb8f2a237ceb3098 -
Branch / Tag:
refs/tags/v1.5.1 - Owner: https://github.com/anentropic
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@2b3580e8d5b8c8f295887d59eb8f2a237ceb3098 -
Trigger Event:
push
-
Statement type:
File details
Details for the file adbc_poolhouse-1.5.1-py3-none-any.whl.
File metadata
- Download URL: adbc_poolhouse-1.5.1-py3-none-any.whl
- Upload date:
- Size: 72.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d5d8809bdfc6b87f2e5e85b8a77f5702c2459b30aec672451d2f475aac1c53cb
|
|
| MD5 |
f2125e45c9ceeb27a695bdf9bc03254b
|
|
| BLAKE2b-256 |
87116b90dcd851e77e8f150a4194b56af91c34e6a0983dcbc299a8e2c4bc9ecd
|
Provenance
The following attestation bundles were made for adbc_poolhouse-1.5.1-py3-none-any.whl:
Publisher:
release.yml on anentropic/adbc-poolhouse
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
adbc_poolhouse-1.5.1-py3-none-any.whl -
Subject digest:
d5d8809bdfc6b87f2e5e85b8a77f5702c2459b30aec672451d2f475aac1c53cb - Sigstore transparency entry: 2099090406
- Sigstore integration time:
-
Permalink:
anentropic/adbc-poolhouse@2b3580e8d5b8c8f295887d59eb8f2a237ceb3098 -
Branch / Tag:
refs/tags/v1.5.1 - Owner: https://github.com/anentropic
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@2b3580e8d5b8c8f295887d59eb8f2a237ceb3098 -
Trigger Event:
push
-
Statement type:
