{"repo":"maximdanilchenko/aiochclient","free":true,"listed":false,"github":"https://github.com/maximdanilchenko/aiochclient","clone":"git clone https://github.com/maximdanilchenko/aiochclient.git","description":"Lightweight async http(s) ClickHouse client for python 3.10+ with types converting","language":"Python","stars":257,"topics":["clickhouse","asyncio","python","aiohttp","async","client","driver","database","httpx"],"license":"MIT","category":"databases-storage","readme_excerpt":"aiochclient An async http(s) ClickHouse client for python 3.10+ supporting type conversion in both directions, streaming, lazy decoding on select queries, and a fully typed interface. Table of Contents - Installation - Quick Start - Binary engines: RowBinary and Native - Documentation - Type Conversion - Connection Pool Settings - Notes on Speed Installation You can use it with either aiohttp or httpx http connectors. To use with aiohttp install it with command: Or aiochclient[aiohttp-speedups] to install with extra speedups. To use with httpx install it with command: Or aiochclient[httpx-speedups] to install with extra speedups. Installing with [ -speedups] adds the following: - faust-cchardet for aiohttp speedup - aiodns for aiohttp speedup - ciso8601 for ultra-fast datetime parsing while decoding data from ClickHouse for aiohttp and httpx . Additionally the installation process attempts to use Cython for a speed boost (roughly 30% faster). Quick Start Connecting to ClickHouse aiochclient needs aiohttp.ClientSession or httpx.AsyncClient to connect to ClickHouse: Querying the database For INSERT queries you can pass values as args . Values should be iterables: For fetching all rows at once use the fetch method: For fetching first row from result use the fetchrow method: You can also use fetchval method, which returns first value of the first row from query result: With async iteration on the query results stream you can fetch multiple rows without loading them all into memor","default_branch":null,"files":null,"tree":[],"storefront":"/r/maximdanilchenko","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/maximdanilchenko/aiochclient/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."}