PHPackages                             itstably/clickhouse-php-client - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [HTTP & Networking](/categories/http)
4. /
5. itstably/clickhouse-php-client

ActiveLibrary[HTTP & Networking](/categories/http)

itstably/clickhouse-php-client
==============================

Clickhouse client over HTTP

2.0.0(6y ago)01941PHPPHP ~7.1

Since Apr 23Pushed 6y agoCompare

[ Source](https://github.com/itstably/clickhouse-php-client)[ Packagist](https://packagist.org/packages/itstably/clickhouse-php-client)[ RSS](/packages/itstably-clickhouse-php-client/feed)WikiDiscussions master Synced today

READMEChangelog (1)Dependencies (4)Versions (4)Used By (1)

Clickhouse Client
=================

[](#clickhouse-client)

Package was written as client for [Clickhouse](https://clickhouse.yandex/).

Client uses [Guzzle](https://github.com/guzzle/guzzle) for sending Http requests to Clickhouse servers.

Requirements
------------

[](#requirements)

`php7.1`

Install
-------

[](#install)

Composer

```
composer require itstably/clickhouse-php-client
```

Usage
=====

[](#usage)

Client works with alone server and cluster. Also, client can make async select and insert (from local files) queries.

Alone server
------------

[](#alone-server)

```
$server = new ItStably\Clickhouse\Server('127.0.0.1', '8123', 'default', 'user', 'pass');
$serverProvider = (new ItStably\Clickhouse\ServerProvider())->addServer($server);

$client = new ItStably\Clickhouse\Client($serverProvider);
```

Cluster
-------

[](#cluster)

```
$testCluster = new ItStably\Clickhouse\Cluster('cluster-name', [
    'server-1' => [
        'host' => '127.0.0.1',
        'port' => '8123',
        'database' => 'default',
        'user' => 'user',
        'password' => 'pass'
    ],
    'server-2' => new ItStably\Clickhouse\Server('127.0.0.1', '8124', 'default', 'user', 'pass')
]);

$anotherCluster = new ItStably\Clickhouse\Cluster('cluster-name', [
    [
        'host' => '127.0.0.1',
        'port' => '8125',
        'database' => 'default',
        'user' => 'user',
        'password' => 'pass'
    ],
    new ItStably\Clickhouse\Server('127.0.0.1', '8126', 'default', 'user', 'pass')
]);

$serverProvider = (new ItStably\Clickhouse\ServerProvider())->addCluster($testCluster)->addCluster($anotherCluster);

$client = (new ItStably\Clickhouse\Client($serverProvider));
```

Before execute any query on cluster, you should provide cluster name and client will run all queries on specified cluster.

```
$client->onCluster('test-cluster');

```

By default client will use random server in given list of servers or in specified cluster. If you want to perform request on specified server you should use `using($hostname)` method on client and then run query. Client will remember hostname for next queries:

```
$client->using('server-2')->select('select * from table');
```

Select queries
--------------

[](#select-queries)

Any SELECT query will return instance of `Result`. This class implements interfaces `\ArrayAccess`, `\Countable` и `\Iterator`, which means that it can be used as an array.

Array with result rows can be obtained via `rows` property

```
$rows = $result->rows;
$rows = $result->getRows();
```

Also you can get some statistic of your query execution:

1. Number of read rows
2. Number of read bytes
3. Time of query execution
4. Rows before limit at least

Statistic can be obtained via `statistic` property

```
$statistic = $result->statistic;
$statistic = $result->getStatistic();

echo $statistic->rows;
echo $statistic->getRows();

echo $statistic->bytes;
echo $statistic->getBytes();

echo $statistic->time;
echo $statistic->getTime();

echo $statistic->rowsBeforeLimitAtLeast;
echo $statistic->getRowsBeforeLimitAtLeast();
```

### Sync

[](#sync)

```
$result = $client->readOne('select number from system.numbers limit 100');

foreach ($result as $number) {
    echo $number['number'].PHP_EOL;
}
```

**Using local files**

You can use local files as temporary tables in Clickhouse. You should pass as third argument array of `TempTable` instances. instance.

In this case will be sent one file to the server from which Clickhouse will extract data to temporary table. Structure of table will be:

- number - UInt64

If you pass such an array as a structure:

```
['UInt64']
```

Then each column from file wil be named as \_1, \_2, \_3.

```
$result = $client->readOne('select number from system.numbers where number in _numbers limit 100', new TempTable('_numbers', 'numbers.csv', [
    'number' => 'UInt64'
]));

foreach ($result as $number) {
    echo $number['number'].PHP_EOL;
}
```

You can provide path to file or pass `FileInterface` instance as second argument.

There is some other types of file streams which could be used to send to server:

- File - simple file stored on disk;
- FileFromString - stream created from string. For example: `new FileFromString('1'.PHP_EOL.'2'.PHP_EOL.'3'.PHP_EOL)`
- MergedFiles - stream which includes many files and merges them all in one. You should pass to constructor file path, which contains list of files which should be megred in one stream.
- TempTable - wrapper to any of `FileInterface` instance and contains structure. Usefull to make inserts using with `MergedFiles`.

### Async

[](#async)

Unlike the `readOne` method, which returns` Result`, the `read` method returns an array of` Result` for each executed query.

```
list($clicks, $visits, $views) = $client->read([
    ['query' => "select * from clicks where date = '2017-01-01'"],
    ['query' => "select * from visits where date = '2017-01-01'"],
    ['query' => "select * from views where date = '2017-01-01'"],
]);

foreach ($clicks as $click) {
    echo $click['date'].PHP_EOL;
}
```

**In `read` method, you can pass the parameter `$concurrency` which is responsible for the maximum simultaneous number of requests.**

**Using local files**

As with synchronous select request you can pass files to the server:

```
list($clicks, $visits, $views) = $client->read([
    ['query' => "select * from clicks where date = '2017-01-01' and userId in _users", new TempTable('_users', 'users.csv', ['number' => 'UInt64'])],
    ['query' => "select * from visits where date = '2017-01-01'"],
    ['query' => "select * from views where date = '2017-01-01'"],
]);

foreach ($clicks as $click) {
    echo $click['date'].PHP_EOL;
}
```

With asynchronous requests you can pass multiple files as with synchronous request.

Insert queries
--------------

[](#insert-queries)

Insert queries always returns true or throws exceptions in case of error.

Data can be written row by row or from local CSV or TSV files.

```
$client->writeOne("insert into table (date, column) values ('2017-01-01',1), ('2017-01-02',2)");
$client->write([
    ['query' => "insert into table (date, column) values ('2017-01-01',1), ('2017-01-02',2)"],
    ['query' => "insert into table (date, column) values ('2017-01-01',1), ('2017-01-02',2)"],
    ['query' => "insert into table (date, column) values ('2017-01-01',1), ('2017-01-02',2)"]
]);

$client->writeFiles('table', ['date', 'column'], [
    new ItStably\Clickhouse\Common\File('/file-1.csv'),
    new ItStably\Clickhouse\Common\File('/file-2.csv')
]);

$client->insertFiles('table', ['date', 'column'], [
    new ItStably\Clickhouse\Common\File('/file-1.tsv'),
    new ItStably\Clickhouse\Common\File('/file-2.tsv')
], ItStably\Clickhouse\Common\Format::TSV);
```

In case of `writeFiles` queries executes asynchronously. If you have butch of files and you want to insert them in one insert query, you can use our `ccat` utility and `MergedFiles` instance instead of `File`. You should put list of files to insert into one file:

```
file-1.tsv
file-2.tsv

```

### Building ccat

[](#building-ccat)

`ccat` sources placed into `utils/ccat` directory. Just run `make && make install` to build and install library into `bin` directory of package. There are already compiled binary of `ccat` in `bin` directory, but it may not work on some systems.

**In `writeFiles` method, you can pass the parameter `$concurrency` which is responsible for the maximum simultaneous number of requests.**

Other queries
-------------

[](#other-queries)

In addition to SELECT and INSERT queries, you can execute other queries :) There is `statement` method for this purposes.

```
$client->writeOne('DROP TABLE table');
```

Testing
-------

[](#testing)

```
$ composer test
```

Roadmap
-------

[](#roadmap)

- Add ability to save query result in local file

Contributing
------------

[](#contributing)

Please send your own pull-requests and make suggestions on how to improve anything. We will be very grateful.

Thx!

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity56

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 74.3% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

2373d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/1743686?v=4)[Vasiliy Razumov](/maintainers/ckjet)[@ckjet](https://github.com/ckjet)

---

Top Contributors

[![FacedSID](https://avatars.githubusercontent.com/u/11896844?v=4)](https://github.com/FacedSID "FacedSID (26 commits)")[![evsign](https://avatars.githubusercontent.com/u/7965780?v=4)](https://github.com/evsign "evsign (8 commits)")[![vasiliy-razumov](https://avatars.githubusercontent.com/u/36407770?v=4)](https://github.com/vasiliy-razumov "vasiliy-razumov (1 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/itstably-clickhouse-php-client/health.svg)

```
[![Health](https://phpackages.com/badges/itstably-clickhouse-php-client/health.svg)](https://phpackages.com/packages/itstably-clickhouse-php-client)
```

###  Alternatives

[spatie/crawler

Crawl all internal links found on a website

2.8k16.3M52](/packages/spatie-crawler)[omniphx/forrest

A Laravel library for Salesforce

2724.4M8](/packages/omniphx-forrest)[akamai-open/edgegrid-client

Implements the Akamai {OPEN} EdgeGrid Authentication specified by https://developer.akamai.com/introduction/Client\_Auth.html

482.5M6](/packages/akamai-open-edgegrid-client)[muhammadhuzaifa/telescope-guzzle-watcher

Telescope Guzzle Watcher provide a custom watcher for intercepting http requests made via guzzlehttp/guzzle php library. The package uses the on\_stats request option for extracting the request/response data. The watcher intercept and log the request into the Laravel Telescope HTTP Client Watcher.

98239.8k1](/packages/muhammadhuzaifa-telescope-guzzle-watcher)[onesignal/onesignal-php-api

A powerful way to send personalized messages at scale and build effective customer engagement strategies. Learn more at onesignal.com

34170.2k2](/packages/onesignal-onesignal-php-api)[ory/hydra-client-php

Documentation for all of Ory Hydra's APIs.

1710.8k](/packages/ory-hydra-client-php)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)