- 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
HttpCompression
set true - Deprecated
StreamInsert
class
Fix:
- Fix
rawData()
result inJSONCompact & JSONEachRow
format - 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\WhereInFile
to\ClickHouseDB\Query\WhereInFile
- Move
\ClickHouseDB\QueryException
to\ClickHouseDB\Exception\QueryException
- Move
\ClickHouseDB\DatabaseException
toClickHouseDB\Exception\DatabaseException
- Move
\ClickHouseDB\FormatLine
to\ClickHouseDB\Quote\FormatLine
- Move
\ClickHouseDB\WriteToFile
toClickHouseDB\Query\WriteToFile
- Move
\Curler\Request
to\ClickHouseDB\Transport\CurlerRequest
- Move
\Curler\CurlerRolling
to\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 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
- progressFunction()
- Escape values
- Not set
FORMAT JSON
if 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=1
cluster->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\Request
no 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