PHPackages                             aozeahj/phpclickhouse - 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. aozeahj/phpclickhouse

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

aozeahj/phpclickhouse
=====================

PHP ClickHouse Client

0.18.05.09(8y ago)028MITPHPPHP ^7.1

Since Aug 6Pushed 7y agoCompare

[ Source](https://github.com/aozeahj/phpClickHouse)[ Packagist](https://packagist.org/packages/aozeahj/phpclickhouse)[ Docs](https://github.com/smi2/phpClickHouse)[ RSS](/packages/aozeahj-phpclickhouse/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependencies (1)Versions (10)Used By (0)

PHP ClickHouse wrapper
======================

[](#php-clickhouse-wrapper)

[![Build Status](https://camo.githubusercontent.com/2eb44417989d253a83bbf7c58fd0fa0afdbbbd94c1e6f57605d74e799f9a3281/68747470733a2f2f7472617669732d63692e6f72672f736d69322f706870436c69636b486f7573652e737667)](https://travis-ci.org/smi2/phpClickHouse)[![Downloads](https://camo.githubusercontent.com/bf19c6cef027523028218472af302aef548eac7bfb7b0ce2c45d93f9668d1b27/68747470733a2f2f706f7365722e707567782e6f72672f736d69322f706870436c69636b486f7573652f642f746f74616c2e737667)](https://packagist.org/packages/smi2/phpClickHouse)[![Packagist](https://camo.githubusercontent.com/de8da63d16f846e42152bd24786b1949a0338bcecec9f2a389244c865b5f77fb/68747470733a2f2f706f7365722e707567782e6f72672f736d69322f706870436c69636b486f7573652f762f737461626c652e737667)](https://packagist.org/packages/smi2/phpClickHouse)[![Licence](https://camo.githubusercontent.com/bd312597937bc9770d869e8336184e89642a8ba7c5c4e3413c671cfac4e189c6/68747470733a2f2f706f7365722e707567782e6f72672f736d69322f706870436c69636b486f7573652f6c6963656e73652e737667)](https://packagist.org/packages/smi2/phpClickHouse)[![Quality Score](https://camo.githubusercontent.com/12ddce98a231e454b40c947e344d04ca36ab8764c6c26ce1d7452abf2ce05fb4/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f736d69322f706870436c69636b486f7573652f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/smi2/phpClickHouse)[![Code Coverage](https://camo.githubusercontent.com/7c87088442bc4650c16ee35a3d207c126b30bbe83b24774ada0f6aaaef3f00a4/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f736d69322f706870436c69636b486f7573652f6261646765732f636f7665726167652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/smi2/phpClickHouse)

Features
--------

[](#features)

- No dependency, only curl (php 5.6 without composer)
- Select parallel queries (asynchronous)
- Parallelizing bulk inserts from CSV file
- enable\_http\_compression, for bulk inserts
- Find active host and check cluster
- Select WHERE IN ( *local csv file* )
- SQL conditions & template
- tablesSize & databaseSize
- listPartitions
- dropPartition & dropOldPartitions
- truncateTable in cluster
- Insert array as column
- Get master node replica in cluster
- Get tableSize in all nodes
- Async get ClickHouse progress function

[Russian articles in repo](https://github.com/smi2/phpClickHouse/blob/master/doc/01_article.md), [on habr 2](https://habrahabr.ru/company/smi2/blog/317682/) [on habr 1](https://habr.com/company/smi2/blog/314558/)

Install composer
----------------

[](#install-composer)

```
composer require smi2/phpclickhouse

```

### OR install submodule

[](#or-install-submodule)

`composer` require php 7.1, but phpClickHouse can work on php >=5.6 without autoload and `composer`

```
git submodule add https://github.com/smi2/phpClickHouse.git
git submodule init

# update
git submodule update --init --recursive
git submodule update --remote
```

In php

```
include_once __DIR__ . '/phpClickHouse/include.php';
$db = new ClickHouseDB\Client(['config_array']);
$db->ping();
```

[Packagist](https://packagist.org/packages/smi2/phpclickhouse)

Start
-----

[](#start)

Connect and select database:

```
$config = [
    'host' => '192.168.1.1',
    'port' => '8123',
    'username' => 'default',
    'password' => ''
];
$db = new ClickHouseDB\Client($config);
$db->database('default');
$db->setTimeout(1.5);      // 1500 ms
$db->setTimeout(10);       // 10 seconds
$db->setConnectTimeOut(5); // 5 seconds
```

Show tables:

```
print_r($db->showTables());
```

Create table:

```
$db->write('
    CREATE TABLE IF NOT EXISTS summing_url_views (
        event_date Date DEFAULT toDate(event_time),
        event_time DateTime,
        site_id Int32,
        site_key String,
        views Int32,
        v_00 Int32,
        v_55 Int32
    )
    ENGINE = SummingMergeTree(event_date, (site_id, site_key, event_time, event_date), 8192)
');
```

Show create table:

```
echo $db->showCreateTable('summing_url_views');
```

Insert data:

```
$stat = $db->insert('summing_url_views',
    [
        [time(), 'HASH1', 2345, 22, 20, 2],
        [time(), 'HASH2', 2345, 12, 9,  3],
        [time(), 'HASH3', 5345, 33, 33, 0],
        [time(), 'HASH3', 5345, 55, 0, 55],
    ],
    ['event_time', 'site_key', 'site_id', 'views', 'v_00', 'v_55']
);
```

Select:

```
$statement = $db->select('SELECT * FROM summing_url_views LIMIT 2');
```

Work with Statement:

```
// Count select rows
$statement->count();

// Count all rows
$statement->countAll();

// fetch one row
$statement->fetchOne();

// get extremes min
print_r($statement->extremesMin());

// totals row
print_r($statement->totals());

// result all
print_r($statement->rows());

// totalTimeRequest
print_r($statement->totalTimeRequest());

// raw answer JsonDecode array, for economy memory
print_r($statement->rawData());

// raw curl_info answer
print_r($statement->responseInfo());

// human size info
print_r($statement->info());

// if clickhouse-server version >= 54011
$db->settings()->set('output_format_write_statistics',true);
print_r($statement->statistics());
```

Select result as tree:

```
$statement = $db->select('
    SELECT event_date, site_key, sum(views), avg(views)
    FROM summing_url_views
    WHERE site_id < 3333
    GROUP BY event_date, url_hash
    WITH TOTALS
');

print_r($statement->rowsAsTree('event_date.site_key'));

/*
(
    [2016-07-18] => Array
        (
            [HASH2] => Array
                (
                    [event_date] => 2016-07-18
                    [url_hash] => HASH2
                    [sum(views)] => 12
                    [avg(views)] => 12
                )
            [HASH1] => Array
                (
                    [event_date] => 2016-07-18
                    [url_hash] => HASH1
                    [sum(views)] => 22
                    [avg(views)] => 22
                )
        )
)
*/
```

Drop table:

```
$db->write('DROP TABLE IF EXISTS summing_url_views');
```

Features
--------

[](#features-1)

### Select parallel queries (asynchronous)

[](#select-parallel-queries-asynchronous)

```
$state1 = $db->selectAsync('SELECT 1 as ping');
$state2 = $db->selectAsync('SELECT 2 as ping');

// run
$db->executeAsync();

// result
print_r($state1->rows());
print_r($state2->fetchOne('ping'));
```

### Parallelizing massive inserts from CSV file

[](#parallelizing-massive-inserts-from-csv-file)

```
$file_data_names = [
    '/tmp/clickHouseDB_test.1.data',
    '/tmp/clickHouseDB_test.2.data',
    '/tmp/clickHouseDB_test.3.data',
    '/tmp/clickHouseDB_test.4.data',
    '/tmp/clickHouseDB_test.5.data',
];

// insert all files
$stat = $db->insertBatchFiles(
    'summing_url_views',
    $file_data_names,
    ['event_time', 'site_key', 'site_id', 'views', 'v_00', 'v_55']
);
```

### Parallelizing errors

[](#parallelizing-errors)

selectAsync without executeAsync

```
$select = $db->selectAsync('SELECT * FROM summing_url_views LIMIT 1');
$insert = $db->insertBatchFiles('summing_url_views', ['/tmp/clickHouseDB_test.1.data'], ['event_time']);
// 'Exception' with message 'Queue must be empty, before insertBatch, need executeAsync'
```

see example/exam5\_error\_async.php

### Gzip &amp; enable\_http\_compression

[](#gzip--enable_http_compression)

On fly read CSV file and compress zlib.deflate.

```
$db->settings()->max_execution_time(200);
$db->enableHttpCompression(true);

$result_insert = $db->insertBatchFiles('summing_url_views', $file_data_names, [...]);

foreach ($result_insert as $fileName => $state) {
    echo $fileName . ' => ' . json_encode($state->info_upload()) . PHP_EOL;
}
```

see speed test `example/exam08_http_gzip_batch_insert.php`

### Max execution time

[](#max-execution-time)

```
$db->settings()->max_execution_time(200); // second
```

### tablesSize &amp; databaseSize

[](#tablessize--databasesize)

Result in *human size*

```
print_r($db->databaseSize());
print_r($db->tablesSize());
print_r($db->tableSize('summing_partions_views'));
```

### Partitions

[](#partitions)

```
$count_result = 2;
print_r($db->partitions('summing_partions_views', $count_result));
```

Drop partitions ( pre production )

```
$count_old_days = 10;
print_r($db->dropOldPartitions('summing_partions_views', $count_old_days));

// by `partition_id`
print_r($db->dropPartition('summing_partions_views', '201512'));
```

### Select WHERE IN ( *local csv file* )

[](#select-where-in--local-csv-file-)

```
$file_name_data1 = '/tmp/temp_csv.txt'; // two column file [int,string]
$whereIn = new \ClickHouseDB\Query\WhereInFile();
$whereIn->attachFile($file_name_data1, 'namex', ['site_id' => 'Int32', 'site_hash' => 'String'], \ClickHouseDB\Query\WhereInFile::FORMAT_CSV);
$result = $db->select($sql, [], $whereIn);

// see example/exam7_where_in.php
```

### Simple sql conditions &amp; template

[](#simple-sql-conditions--template)

conditions is deprecated, if need use: `$db->enableQueryConditions();`

Example with QueryConditions:

```
$db->enableQueryConditions();

$input_params = [
  'select_date' => ['2000-10-10', '2000-10-11', '2000-10-12'],
  'limit' => 5,
  'from_table' => 'table'
];

$select = '
    SELECT * FROM {from_table}
    WHERE
    {if select_date}
        event_date IN (:select_date)
    {else}
        event_date=today()
    {/if}
    {if limit}
    LIMIT {limit}
    {/if}
';

$statement = $db->selectAsync($select, $input_params);
echo $statement->sql();

/*
SELECT * FROM table
WHERE
event_date IN ('2000-10-10','2000-10-11','2000-10-12')
LIMIT 5
FORMAT JSON
*/

$input_params['select_date'] = false;
$statement = $db->selectAsync($select, $input_params);
echo $statement->sql();

/*
SELECT * FROM table
WHERE
event_date=today()
LIMIT 5
FORMAT JSON
*/

$state1 = $db->selectAsync(
    'SELECT 1 as {key} WHERE {key} = :value',
    ['key' => 'ping', 'value' => 1]
);

// SELECT 1 as ping WHERE ping = "1"
```

Example custom query Degeneration in `exam16_custom_degeneration.php`

```
SELECT {ifint VAR} result_if_intval_NON_ZERO{/if}
SELECT {ifint VAR} result_if_intval_NON_ZERO {else} BLA BLA{/if}

```

### Settings

[](#settings)

3 way set any settings

```
// in array config
$config = [
    'host' => 'x',
    'port' => '8123',
    'username' => 'x',
    'password' => 'x',
    'settings' => ['max_execution_time' => 100]
];
$db = new ClickHouseDB\Client($config);

// settings via constructor
$config = [
    'host' => 'x',
    'port' => '8123',
    'username' => 'x',
    'password' => 'x'
];
$db = new ClickHouseDB\Client($config, ['max_execution_time' => 100]);

// set method
$config = [
    'host' => 'x',
    'port' => '8123',
    'username' => 'x',
    'password' => 'x'
];
$db = new ClickHouseDB\Client($config);
$db->settings()->set('max_execution_time', 100);

// apply array method
$db->settings()->apply([
    'max_execution_time' => 100,
    'max_block_size' => 12345
]);

// check
if ($db->settings()->getSetting('max_execution_time') !== 100) {
    throw new Exception('Bad work settings');
}

// see example/exam10_settings.php
```

### Use session\_id with ClickHouse

[](#use-session_id-with-clickhouse)

`useSession()` - make new session\_id or use exists `useSession(value)`

```
// enable session_id
$db->useSession();
$sesion_AA=$db->getSession(); // return session_id

$db->write(' CREATE TEMPORARY TABLE IF NOT EXISTS temp_session_test (number UInt64)');
$db->write(' INSERT INTO temp_session_test SELECT number*1234 FROM system.numbers LIMIT 30');

// reconnect to continue with other session
$db->useSession($sesion_AA);
```

### Array as column

[](#array-as-column)

```
$db->write('
    CREATE TABLE IF NOT EXISTS arrays_test_string (
        s_key String,
        s_arr Array(String)
    )
    ENGINE = Memory
');

$db->insert('arrays_test_string',
    [
        ['HASH1', ["a", "dddd", "xxx"]],
        ['HASH1', ["b'\tx"]],
    ],
    ['s_key', 's_arr']
);

// see example/exam12_array.php
```

Class for FormatLine array

```
var_dump(
    \ClickHouseDB\FormatLine::CSV(
        ['HASH1', ["a", "dddd", "xxx"]]
    )
);

var_dump(
    \ClickHouseDB\FormatLine::TSV(
        ['HASH1', ["a", "dddd", "xxx"]]
    )
);

// example write to file
$row=['event_time'=>date('Y-m-d H:i:s'),'arr1'=>[1,2,3],'arrs'=>["A","B\nD\nC"]];
file_put_contents($fileName,\ClickHouseDB\FormatLine::TSV($row)."\n",FILE_APPEND);
```

### Cluster drop old Partitions

[](#cluster-drop-old-partitions)

Example code :

```
class my
{
    /**
     * @return \ClickHouseDB\Cluster
     */
    public function getClickHouseCluster()
    {
            return $this->_cluster;
    }

    public function msg($text)
    {
            echo $text."\n";
    }

    private function cleanTable($dbt)
    {

        $sizes=$this->getClickHouseCluster()->getSizeTable($dbt);
        $this->msg("Clean table : $dbt,size = ".$this->humanFileSize($sizes));

        // split string "DB.TABLE"
        list($db,$table)=explode('.',$dbt);

        // Get Master node for table
        $nodes=$this->getClickHouseCluster()->getMasterNodeForTable($dbt);
        foreach ($nodes as $node)
        {
            $client=$this->getClickHouseCluster()->client($node);

            $size=$client->database($db)->tableSize($table);

            $this->msg("$node \t {$size['size']} \t {$size['min_date']} \t {$size['max_date']}");

            $client->dropOldPartitions($table,30,30);
        }
    }

    public function clean()
    {
        $this->msg("clean");

        $this->getClickHouseCluster()->setScanTimeOut(2.5); // 2500 ms
        $this->getClickHouseCluster()->setSoftCheck(true);
        if (!$this->getClickHouseCluster()->isReplicasIsOk())
        {
            throw new Exception('Replica state is bad , error='.$this->getClickHouseCluster()->getError());
        }

        $this->cleanTable('model.history_full_model_sharded');

        $this->cleanTable('model.history_model_result_sharded');
    }
}
```

### HTTPS

[](#https)

```
$db = new ClickHouseDB\Client($config);
$db->settings()->https();
```

### ReadOnly ClickHouse user

[](#readonly-clickhouse-user)

```
$config = [
    'host' => '192.168.1.20',
    'port' => '8123',
    'username' => 'ro',
    'password' => 'ro',
    'readonly' => true
];
```

### Direct write to file

[](#direct-write-to-file)

Send result from clickhouse, without parse json.

```
$WriteToFile=new ClickHouseDB\WriteToFile('/tmp/_1_select.csv');
$db->select('select * from summing_url_views',[],null,$WriteToFile);
// or
$db->selectAsync('select * from summing_url_views limit 4',[],null,new ClickHouseDB\WriteToFile('/tmp/_3_select.tab',true,'TabSeparatedWithNames'));
$db->selectAsync('select * from summing_url_views limit 4',[],null,new ClickHouseDB\WriteToFile('/tmp/_4_select.tab',true,'TabSeparated'));
$statement=$db->selectAsync('select * from summing_url_views limit 54',[],null,new ClickHouseDB\WriteToFile('/tmp/_5_select.csv',true,ClickHouseDB\WriteToFile::FORMAT_CSV));
```

### insert Assoc Bulk

[](#insert-assoc-bulk)

```
 $oneRow = [
            'one' => 1,
            'two' => 2,
            'thr' => 3,
            ];
            $failRow = [
                'two' => 2,
                'one' => 1,
                'thr' => 3,
            ];

$db->insertAssocBulk([$oneRow, $oneRow, $failRow])
```

### progressFunction

[](#progressfunction)

```
// Apply function

$db->progressFunction(function ($data) {
    echo "CALL FUNCTION:".json_encode($data)."\n";
});
$st=$db->select('SELECT number,sleep(0.2) FROM system.numbers limit 5');

// Print
// ...
// CALL FUNCTION:{"read_rows":"2","read_bytes":"16","total_rows":"0"}
// CALL FUNCTION:{"read_rows":"3","read_bytes":"24","total_rows":"0"}
// ...
```

### Cluster

[](#cluster)

```
$config = [
    'host' => 'cluster.clickhouse.dns.com', // any node name in cluster
    'port' => '8123',
    'username' => 'default', // all node have one login+password
    'password' => ''
];

// client connect first node, by DNS, read list IP, then connect to ALL nodes for check is !OK!

$cl = new ClickHouseDB\Cluster($config);
$cl->setScanTimeOut(2.5); // 2500 ms, max time connect per one node

// Check replica state is OK
if (!$cl->isReplicasIsOk())
{
    throw new Exception('Replica state is bad , error='.$cl->getError());
}

// get array nodes, and clusers
print_r($cl->getNodes());
print_r($cl->getClusterList());

// get node by cluster
$name='some_cluster_name';
print_r($cl->getClusterNodes($name));

// get counts
echo "> Count Shard   = ".$cl->getClusterCountShard($name)."\n";
echo "> Count Replica = ".$cl->getClusterCountReplica($name)."\n";

// get nodes by table & print size per node
$nodes=$cl->getNodesByTable('shara.adpreview_body_views_sharded');
foreach ($nodes as $node)
{
    echo "$node > \n";
    // select one node
    print_r($cl->client($node)->tableSize('adpreview_body_views_sharded'));
    print_r($cl->client($node)->showCreateTable('shara.adpreview_body_views'));
}

// work with one node

// select by IP like "*.248*" = `123.123.123.248`, dilitmer `;`  , if not fount -- select first node
$cli=$cl->clientLike($name,'.298;.964'); // first find .298 then .964 , result is ClickHouseDB\Client

$cli->ping();

// truncate table on cluster
$result=$cl->truncateTable('dbNane.TableName_sharded');

// get one active node ( random )
$cl->activeClient()->setTimeout(0.01);
$cl->activeClient()->write("DROP TABLE IF EXISTS default.asdasdasd ON CLUSTER cluster2");

// find `is_leader` node
$cl->getMasterNodeForTable('dbNane.TableName_sharded');

// errors
var_dump($cl->getError());

//
```

### Return Extremes

[](#return-extremes)

```
$db->enableExtremes(true);
```

### Enable Log Query

[](#enable-log-query)

You can log all query in ClickHouse

```
$db->enableLogQueries();
$db->select('SELECT 1 as p');
print_r($db->select('SELECT * FROM system.query_log')->rows());
```

### isExists

[](#isexists)

```
$db->isExists($database,$table);
```

### Debug &amp; Verbose

[](#debug--verbose)

```
$db->verbose();
```

### Dev &amp; PHPUnit Test

[](#dev--phpunit-test)

- Don't forget to run composer install. It should setup PSR-4 autoloading.
- Then you can simply run vendor/bin/phpunit and it should output the following

In phpunit.xml change constants:

```

```

Run test

```
./vendor/bin/phpunit

./vendor/bin/phpunit --group ClientTest

```

Run PHPStan

```
# Main
./vendor/bin/phpstan analyse src tests

# Examples
./vendor/bin/phpstan analyse example -a ./example/Helper.php

```

License
-------

[](#license)

MIT

ChangeLog
---------

[](#changelog)

### 2018-05-09

[](#2018-05-09)

- Move `\ClickHouseDB\WhereInFile` to `\ClickHouseDB\Query\WhereInFile`
- Move `\ClickHouseDB\QueryException` to `\ClickHouseDB\Exception\QueryException`
- Move `\ClickHouseDB\DatabaseException` to `ClickHouseDB\Exception\DatabaseException`
- Move `\ClickHouseDB\FormatLine` to `\ClickHouseDB\Quote\FormatLine`
- Move `\ClickHouseDB\WriteToFile` to `ClickHouseDB\Query\WriteToFile`
- Move `\Curler\Request` to `\ClickHouseDB\Transport\CurlerRequest`
- Move `\Curler\CurlerRolling` to `\ClickHouseDB\Transport\CurlerRolling`
- Up to php 7.2 &amp; phpunit 7.1 for Dev &amp; Prs4 Autoloading

### 2018-03-26

[](#2018-03-26)

- Fix StreamInsert : one stream work faster and safe than loop #PR43
- Fix cluster-&gt;clientLike()

### 2017-12-28

[](#2017-12-28)

- Fix `FORMAT JSON` if set FORMAT in sql
- GetRaw() - result raw response if not json `SELECT number as format_id FROM system.numbers LIMIT 3 FORMAT CSVWithNames`

### 2017-12-22

[](#2017-12-22)

- progressFunction()
- Escape values

### 2017-12-12

[](#2017-12-12)

- Not set `FORMAT JSON` if set FORMAT in sql

### 2017-11-22

[](#2017-11-22)

- Add insertAssocBulk

### 2017-08-25

[](#2017-08-25)

- Fix tablesSize(), use database filter
- Fix partitions(), use database filter

### 2017-08-14

[](#2017-08-14)

- Add session\_id support

### 2017-02-20

[](#2017-02-20)

- Build composer 0.17.02

### 2016-12-09

[](#2016-12-09)

- for ReadOnly users need set : `client->setReadOnlyUser(true);` or `$confi['readonly']` , see exam19\_readonly\_user.php

### 2016-11-25

[](#2016-11-25)

- `client->truncateTable('tableName')`
- `cluster->getMasterNodeForTable('dbName.tableName') // node have is_leader=1`
- `cluster->getSizeTable('dbName.tableName')`
- `cluster->getTables()`
- `cluster->truncateTable('dbName.tableName')`
- See example cluster\_06\_truncate\_table.php

### 2016-11-24

[](#2016-11-24)

- add `cluster->setSoftCheck()`
- insertBatchFiles() support `$file_names` - string or array , `$columns_array` - array or null
- add insertBatchStream() return `\Curler\Request` no exec
- writeStreamData() return `\Curler\Request`
- fix httpCompression(false)
- getHeaders() as array from `\Curler\Request`
- `setReadFunction( function() )` in `Request`
- Add class StreamInsert, direct read from stream\_resource to clickhouse:stream

### 2016-11-04

[](#2016-11-04)

- add `$db->insertBatchTSVFiles()`,
- add format param in `$db->insertBatchFiles(,,,format)`,
- deprecated class CSV
- Add static class `\ClickHouseDB\FormatLine:CSV(),\ClickHouseDB\FormatLine:TSV(),\ClickHouseDB\FormatLine:Insert()`
- CSV RFC4180 - `\ClickHouseDB\FormatLine::CSV(Array))."\n"`
- Update exam12\_array.php + unit tests

### 2016-11-03

[](#2016-11-03)

- `$db->enableLogQueries(true)` - write to system.query\_log
- `$db->enableExtremes(true);` - default extremes now, disabled
- `$db->isExists($database,$table)`

### 2016-10-27

[](#2016-10-27)

- add Connect timeout , $db-&gt;setConnectTimeOut(5);
- change default ConnectTimeOut = 5 seconds. before 1 sec.
- change DNS\_CACHE default to 120 seconds

### 2016-10-25 Release 0.16.10

[](#2016-10-25-release-01610)

- fix timeout error and add test

### 2016-10-23

[](#2016-10-23)

- client-&gt;setTimeout($seconds)
- cluster-&gt;clientLike($cluster,$ip\_addr\_like)
- Delete all migration code from driver, move to

### 2016-09-20 Release 0.16.09

[](#2016-09-20-release-01609)

- Version/Release names: \[ zero dot year dot month\]
- Support cluster: new class Cluster and ClusterQuery
- output\_format\_write\_statistics, for clickhouse version &gt; v1.1.54019-stable
- WriteToFile in select,selectAsync
- Degeneration for Bindings &amp; Conditions
- $db-&gt;select(new Query("Select..."));
- remove findActiveHostAndCheckCluster , clusterHosts , checkServerReplicas
- Add cleanQueryDegeneration(),addQueryDegeneration()
- Need $db-&gt;enableQueryConditions(); for use Conditions ; default Conditions - disabled;
- float in CurlerRequest-&gt;timeOut(2.5) = 2500 ms
- tablesSize() - add `sizebytes`

### 2016-08-11 Release 0.2.0

[](#2016-08-11-release-020)

- exception on error write

### 2016-08-06 Release 0.1.0

[](#2016-08-06-release-010)

- init

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community15

Small or concentrated contributor base

Maturity54

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 89.9% 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

Every ~80 days

Recently: every ~110 days

Total

9

Last Release

2925d ago

PHP version history (2 changes)0.1.0PHP &gt;=5.5.0

0.18.05.09PHP ^7.1

### Community

Maintainers

![](https://www.gravatar.com/avatar/d2d019e4f643e523e138a0221da5c511bc14490e9008a695fcdf35086f7858a4?d=identicon)[aozeahj](/maintainers/aozeahj)

---

Top Contributors

[![isublimity](https://avatars.githubusercontent.com/u/1861412?v=4)](https://github.com/isublimity "isublimity (293 commits)")[![simPod](https://avatars.githubusercontent.com/u/327717?v=4)](https://github.com/simPod "simPod (12 commits)")[![dmitriy-gladkih](https://avatars.githubusercontent.com/u/6246868?v=4)](https://github.com/dmitriy-gladkih "dmitriy-gladkih (9 commits)")[![andsm](https://avatars.githubusercontent.com/u/2169786?v=4)](https://github.com/andsm "andsm (3 commits)")[![mavimo](https://avatars.githubusercontent.com/u/43941?v=4)](https://github.com/mavimo "mavimo (1 commits)")[![moknomo](https://avatars.githubusercontent.com/u/2641095?v=4)](https://github.com/moknomo "moknomo (1 commits)")[![SerafimArts](https://avatars.githubusercontent.com/u/2461257?v=4)](https://github.com/SerafimArts "SerafimArts (1 commits)")[![serghacker](https://avatars.githubusercontent.com/u/7020844?v=4)](https://github.com/serghacker "serghacker (1 commits)")[![shepik](https://avatars.githubusercontent.com/u/203454?v=4)](https://github.com/shepik "shepik (1 commits)")[![tabuna](https://avatars.githubusercontent.com/u/5102591?v=4)](https://github.com/tabuna "tabuna (1 commits)")[![FallDi](https://avatars.githubusercontent.com/u/4299295?v=4)](https://github.com/FallDi "FallDi (1 commits)")[![Har01d](https://avatars.githubusercontent.com/u/14060856?v=4)](https://github.com/Har01d "Har01d (1 commits)")[![iShift](https://avatars.githubusercontent.com/u/426427?v=4)](https://github.com/iShift "iShift (1 commits)")

---

Tags

httpclientcurlhttp clientdriverclickhouse

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/aozeahj-phpclickhouse/health.svg)

```
[![Health](https://phpackages.com/badges/aozeahj-phpclickhouse/health.svg)](https://phpackages.com/packages/aozeahj-phpclickhouse)
```

###  Alternatives

[smi2/phpclickhouse

PHP ClickHouse Client

83510.1M71](/packages/smi2-phpclickhouse)[aplus/http-client

Aplus Framework HTTP Client Library

2161.6M1](/packages/aplus-http-client)[8bitov/clickhouse-php-client

6966.6k](/packages/8bitov-clickhouse-php-client)[simpod/clickhouse-client

PHP ClickHouse Client

19116.7k](/packages/simpod-clickhouse-client)

PHPackages © 2026

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