Download the PHP package enginema/phpclickhouse without Composer
On this page you can find all versions of the php package enginema/phpclickhouse. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download enginema/phpclickhouse
More information about enginema/phpclickhouse
Files in enginema/phpclickhouse
Package phpclickhouse
Short Description PHP ClickHouse Client
License MIT
Homepage https://github.com/smi2/phpClickHouse
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package phpclickhouse
PHP ClickHouse wrapper
Features
- No dependency, only Curl (support php
>=7.1) - Select parallel queries (asynchronous)
- Asynchronous bulk inserts from CSV file
- Http compression (Gzip), for bulk inserts
- Find active host, check cluster
- Select WHERE IN ( local csv file )
- SQL conditions & template
- tablesSize & databaseSize
- listPartitions
- truncateTable in cluster
- Insert array as column
- Get master node replica in cluster
- Get tableSize in all nodes
- Async get ClickHouse progress function
- streamRead/Write & Closure functions
Russian articles habr.com 1 on habr.com 2
Install composer
In php
Last stable version for
- php 5.6 <=
1.1.2 - php 7.2 <=
1.3.10 - php 7.3 >=
1.4.x
Start
Connect and select database:
Show tables:
Create table:
Show create table:
Insert data:
If you need to insert UInt64 value, you can wrap the value in ClickHouseDB\Type\UInt64 DTO.
Select:
Work with Statement:
Select result as tree:
Drop table:
Features
Select parallel queries (asynchronous)
Parallelizing massive inserts from CSV file
Parallelizing errors
selectAsync without executeAsync
see example/exam5_error_async.php
Gzip & enable_http_compression
On fly read CSV file and compress zlib.deflate.
see speed test example/exam08_http_gzip_batch_insert.php
Max execution time
Connection without port
tablesSize & databaseSize
Result in human size
Partitions
Select WHERE IN ( local csv file )
Bindings
Bindings:
Simple sql conditions & template
Conditions is deprecated, if need use:
$db->enableQueryConditions();
Example with QueryConditions:
Example custom query Degeneration in exam16_custom_degeneration.php
Settings
3 way set any settings
Use session_id with ClickHouse
useSession() - make new session_id or use exists useSession(value)
Array as column
Class for FormatLine array
HTTPS
getServer System.Settings & Uptime
ReadOnly ClickHouse user
Direct write to file
Send result from clickhouse, without parse json.
Stream
streamWrite() : Closure stream write
streamWrite & custom Closure & Deflate
streamRead
streamRead is like WriteToFile
insert Assoc Bulk
Auth methods
In config set auth_method
progressFunction
ssl CA
Cluster
Return Extremes
Enable Log Query
You can log all query in ClickHouse
isExists
Debug & Verbose
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
Edit in phpunit.xml constants:
Run docker ClickHouse server
Run test
Run PHPStan
License
MIT
ChangeLog
See changeLog.md
All versions of phpclickhouse with dependencies
ext-curl Version *
ext-json Version *