{"repo":"simPod/PhpClickHouseClient","free":true,"listed":false,"github":"https://github.com/simPod/PhpClickHouseClient","clone":"git clone https://github.com/simPod/PhpClickHouseClient.git","description":"PHP ClickHouse Client over HTTP","language":"PHP","stars":19,"topics":["clickhouse","clickhouse-client","hacktoberfest","php"],"license":"MIT","category":"databases-storage","readme_excerpt":"PHP ClickHouse Client [![Code Coverage][Coverage image]][CodeCov Master] Motivation The library is trying not to hide any ClickHouse HTTP interface specific details. That said everything is as much transparent as possible and so object-oriented API is provided without inventing own abstractions. Naming used here is the same as in ClickHouse docs. - Works with any HTTP Client implementation (PSR-18 compliant) - All ClickHouse Formats support - Logging (PSR-3 compliant) - SQL Factory for parameters \"binding\" - Native query parameters support Contents - Setup - Logging - PSR Factories who? - Sync API - Select - Select With Params - Insert - Async API - Select - Parameters \"binding\" - Native Query Parameters - Custom Query Parameter Value Conversion - Expression - Snippets Setup 1. Read about ClickHouse HTTP Interface. It's short and useful for concept understanding. 2. Create a new instance of ClickHouse client and pass a PSR-18 HTTP client plus PSR-17 factories. 1. Symfony HttpClient is recommended for the PSR-18 client. 2. The plot twist is there's no endpoint/credentials etc. config in this library, provide it via client. 3. See tests Logging Pass a SqlLogger implementation as the third PsrClickHouseClient constructor argument. The library provides a PSR-3 adapter: Symfony HttpClient Example Configure HTTP Client As said in ClickHouse HTTP Interface spec, we use headers to auth and e.g. set default database via query. PSR Factories who? The library does not implement its own ","default_branch":null,"files":null,"tree":[],"storefront":"/r/simPod","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/simPod/PhpClickHouseClient/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."}