phpClickHouse

2018-08-30 [Release 1.2.3]

• Escape values in arrays, pull request #87 from simPod/fix-escape
• fix-bindings: pull request #84 from simPod/fix-bindings
• Added quotes arount table and column names in the insert wrapper.
• Docker Compose in tests

• Connection without port

Release 1.2.1

• New $client->getServerVersion()
• Rewrite method $client->ping()
• Fix include.php - ClickHouseException before exceptions
• Add CHANGELOG.md
• New interface ClickHouseException

Bindings wrong work - fix

$keys=[
            'A'=>'{B}',
            'B'=>':C',
            'C'=>123,
            'Z'=>[':C',':B',':C']
        ];
$this->client->selectAsync('{A} :Z', $keys)->sql() // ==   "123 ':C',':B',':C' FORMAT JSON",

Bindings wrong work - fix

$keys=[
            'A'=>'{B}',
            'B'=>':C',
            'C'=>123,
            'Z'=>[':C',':B',':C']
        ];
$this->client->selectAsync('{A} :Z', $keys)->sql() // ==   "123 ':C',':B',':C' FORMAT JSON",

2018-07-02 [Release 1.1.0]

New:

• $client->getServerUptime() Returns the server's uptime in seconds.
• $client->getServerSystemSettings() Read system.settings table and return array
• $client->streamWrite() function
• $client->streamRead() function

Warning:

• Now default enableHttpCompression set true
• Deprecated StreamInsert class

Fix:

• Fix rawData() result in JSONCompact & JSONEachRow format
• Fix Statement - unnecessary memory usage
• Fix support php5.6

1.0.1
Do not convert int parameters in array to string in Bindings pull 67

Use Semantic versioning

0.18.06.19

• Add DateTimeInterface for Bind
• Fix phpDocs in code

0.18.06.18
Try fix problem with php 5.6

0.18.06.17 -> PHP 5.6

0.18.05.09

WARN!!!

!Move class in namespace!
!Check your code!

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

0.17.12.1

• progressFunction()
• Escape values

0.17.11

See changelog

See readme, change log

New:

• setConnectTimeOut
• Delete all migration code from driver
• Degeneration for Bindings & Conditions
• Use enableQueryConditions for compatibility
• setReadOnlyUser
• truncateTable

2016-10-25 Release 0.16.10

fix timeout error and add test
2016-10-23

client->setTimeout($seconds)
cluster->clientLike($cluster,$ip_addr_like)
Delete all migration code from driver, move to https://github.com/smi2/phpMigrationsClickhouse

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

warn! drop Conditions

see example/exam16_custom_degeneration.php