SeasClick

PHP client for Yandex ClickHouse，Based on ClickHouse C++ client

ClickHouse

• What is ClickHouse
• ClickHouse Performance
• Performance comparison with MySQL

Supported data types

• Array(T) Multidimensional arrays are not supported at this time
• Date
• DateTime
• Decimal32, Decimal64, Decimal128
• Enum8, Enum16
• FixedString(N)
• Float32, Float64
• Nullable(T)
• String
• UInt8, UInt16, UInt32, UInt64, Int8, Int16, Int32, Int64

Supported PHP version

PHP 5.4+

Performance

This performance test demo is compared to phpclickhouse

Install

git clone https://github.com/SeasX/SeasClick.git
cd SeasClick
phpize
./configure
make && make install

Example

<?php
$config = [
    "host" => "clickhouse",
    "port" => 9000,
    "compression" => true
];

clientTest($config);

function clientTest($config)
{
    $deleteTable = true;
    $client = new SeasClick($config);

    $client->execute("CREATE DATABASE IF NOT EXISTS test");

    testArray($client, $deleteTable);
}

function testArray($client, $deleteTable = false) {
    $client->execute("CREATE TABLE IF NOT EXISTS test.array_test (string_c String, array_c Array(Int8), arraynull_c Array(Nullable(String))) ENGINE = Memory");

    $client->insert("test.array_test", [
        'string_c', 'array_c', 'arraynull_c'
    ], [
        ['string_c1', [1, 2, 3], ['string']],
        ['string_c2', [4, 5, 6], [null]]
    ]);

    $result = $client->select("SELECT {select} FROM {table}", [
        'select' => 'string_c, array_c, arraynull_c',
        'table' => 'test.array_test'
    ]);
    var_dump($result);

    if ($deleteTable) {
        $client->execute("DROP TABLE {table}", [
            'table' => 'test.array_test'
        ]);
    }
}

More examples

Support

SeasX Group