- Connection without port
- New
$client->getServerVersion() - Rewrite method
$client->ping() - Fix
include.php- ClickHouseException before exceptions - Add CHANGELOG.md
- New
interface ClickHouseException
- Fix
SelectAsync() & executeAsync(), some task freeze
- Republic 1.1.1
- #47 Bindings wrong work - fix
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 enable
HttpCompressionset true - Deprecated
StreamInsertclass
Fix:
- Fix
rawData()result inJSONCompact & JSONEachRowformat - Fix Statement - unnecessary memory usage
- Fix support php5.6
- Do not convert int parameters in array to string in Bindings pull 67
- Use Semantic versioning
- Fix
tableSize('name')andtablesSize()
- Add DataTime Interface for Bind
- Fix phpDoc
Composer->require->"php": ">=5.6"
- Move
\ClickHouseDB\WhereInFileto\ClickHouseDB\Query\WhereInFile - Move
\ClickHouseDB\QueryExceptionto\ClickHouseDB\Exception\QueryException - Move
\ClickHouseDB\DatabaseExceptiontoClickHouseDB\Exception\DatabaseException - Move
\ClickHouseDB\FormatLineto\ClickHouseDB\Quote\FormatLine - Move
\ClickHouseDB\WriteToFiletoClickHouseDB\Query\WriteToFile - Move
\Curler\Requestto\ClickHouseDB\Transport\CurlerRequest - Move
\Curler\CurlerRollingto\ClickHouseDB\Transport\CurlerRolling - Up to php 7.2 & phpunit 7.1 for Dev & Prs4 Autoloading
- Fix StreamInsert : one stream work faster and safe than loop #PR43
- Fix cluster->clientLike()
- Fix
FORMAT JSONif set FORMAT in sql - GetRaw() - result raw response if not json
SELECT number as format_id FROM system.numbers LIMIT 3 FORMAT CSVWithNames
- progressFunction()
- Escape values
- Not set
FORMAT JSONif set FORMAT in sql
- Add insertAssocBulk
- Fix tablesSize(), use database filter
- Fix partitions(), use database filter
- Add session_id support
- Build composer 0.17.02
- for ReadOnly users need set :
client->setReadOnlyUser(true);or$confi['readonly'], see exam19_readonly_user.php
client->truncateTable('tableName')cluster->getMasterNodeForTable('dbName.tableName') // node have is_leader=1cluster->getSizeTable('dbName.tableName')cluster->getTables()cluster->truncateTable('dbName.tableName')- See example cluster_06_truncate_table.php
- add
cluster->setSoftCheck() - insertBatchFiles() support
$file_names- string or array ,$columns_array- array or null - add insertBatchStream() return
\Curler\Requestno exec - writeStreamData() return
\Curler\Request - fix httpCompression(false)
- getHeaders() as array from
\Curler\Request setReadFunction( function() )inRequest- Add class StreamInsert, direct read from stream_resource to clickhouse:stream
- 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
$db->enableLogQueries(true)- write to system.query_log$db->enableExtremes(true);- default extremes now, disabled$db->isExists($database,$table)
- add Connect timeout , $db->setConnectTimeOut(5);
- change default ConnectTimeOut = 5 seconds. before 1 sec.
- change DNS_CACHE default to 120 seconds
- fix timeout error and add test
- 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
- exception on error write
- init