{"repo":"long2ice/asynch","free":true,"listed":false,"github":"https://github.com/long2ice/asynch","clone":"git clone https://github.com/long2ice/asynch.git","description":"An asyncio ClickHouse Python Driver with native (TCP) interface support.","language":"Python","stars":244,"topics":["asyncio","clickhouse","driver","native","yandex"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"asynch Introduction asynch is an asynchronous ClickHouse Python driver with native TCP interface support, complying with PEP 249. - Fast : the protocol hot path (streams, column codecs, connection, cursors) is compiled with Cython — it matches or beats clickhouse-driver, the synchronous C-extension driver, while staying fully asynchronous (see Performance) - asyncio-native : async / await everywhere, with a built-in connection pool and streaming result sets - PEP 249 API : Connection , Cursor / DictCursor , familiar execute / fetch semantics - Typed : ships .pyi stubs for the compiled modules (PEP 561) Installation Binary wheels are published for Linux (x86 64/arm64), Windows and macOS (Intel/ARM) on Python 3.11–3.14 — no compiler needed. On platforms without a wheel, the sdist compiles from source and requires a C toolchain. If you want to install clickhouse-cityhash to enable transport compression Usage Basically, a connection to a ClickHouse server can be established in two ways: 1. with a DSN string, e.g., clickhouse://[user:password]@host:port/database ; 2. with separately given connection/DSN parameters: user (optional), password (optional), host , port , database . If a DSN string is given, it takes priority over any specified connection parameter. Create a database and a table by executing SQL statements via an instance of the Cursor class (here its child DictCursor class) acquired from an instance of the Connection class. Fetching one row from an executed SQL stateme","default_branch":null,"files":null,"tree":[],"storefront":"/r/long2ice","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/long2ice/asynch/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}