ClickHouse Pool for Python
A thread-safe connection pool for ClickHouse. Inspired by psycopg2 and using
clickhouse-driver for
connections.
Installation
pip install clickhouse-pool
Quick Start
from clickhouse_pool import ChPool
pool = ChPool()
with pool.get_client() as client:
# execute sql and print the result
result = client.execute("SELECT * FROM system.numbers LIMIT 5")
print(result)
# always close all connections in the pool once you're done with it
pool.cleanup()
Connection Pool Size
To change the connection pool size,
pool = ChPool(connections_min=20, connections_max=40)
with pool.get_client() as client:
result = client.execute("SELECT * FROM system.numbers LIMIT 5")
print(result)
# always close all connections in the pool once you're done with it
pool.cleanup()
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
clickhouse-pool-0.3.0.tar.gz
(3.3 kB
view details)
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 clickhouse-pool-0.3.0.tar.gz.
File metadata
- Download URL: clickhouse-pool-0.3.0.tar.gz
- Upload date:
- Size: 3.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.1.1 pkginfo/1.5.0.1 requests/2.24.0 setuptools/47.3.1 requests-toolbelt/0.9.1 tqdm/4.46.1 CPython/3.8.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
cc46ece95f4e7fa785e33355a45ae80e7c42384200589f1bd9e1a4c9ba6789a3
|
|
| MD5 |
b2b0c7d76f123b05df24fd749b5e356d
|
|
| BLAKE2b-256 |
f93a7cbece42eb6b92e95973a03b145ee874a149f11f4d6b93853d886b93e82b
|
File details
Details for the file clickhouse_pool-0.3.0-py3-none-any.whl.
File metadata
- Download URL: clickhouse_pool-0.3.0-py3-none-any.whl
- Upload date:
- Size: 4.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.1.1 pkginfo/1.5.0.1 requests/2.24.0 setuptools/47.3.1 requests-toolbelt/0.9.1 tqdm/4.46.1 CPython/3.8.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
4e68316a9be477a6759dea5673da3acf3508535303e6621b1d87f4c654efbce1
|
|
| MD5 |
ec4b8b848ddb02f49a8443a1cc340d1c
|
|
| BLAKE2b-256 |
44f0e185c1106ef90794bdc33b08f33102ef9f795479094fcea46f34210b1a44
|
