Download the PHP package kak/clickhouse without Composer
On this page you can find all versions of the php package kak/clickhouse. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download kak/clickhouse
More information about kak/clickhouse
Files in kak/clickhouse
Informations about the package clickhouse
Yii2 ClickHouse extension
Installation
Composer
The preferred way to install this extension is through Composer.
Either run
- stable
php composer.phar require kak/clickhouse ~1.1
- dev
php composer.phar require kak/clickhouse @dev
or add to composer.json manual
- stable
"kak/clickhouse": "~1.1
- dev
"kak/clickhouse": "@dev"
to the require section of your composer.json
Configuration example
Notes
- If clickhouse server responds with no response == 200, then you will get the exception
Usage
batch insert files
batch insert files, batch size = 100 lines
old methods: meta, rows, countAll, statistics
old examples ORM
Set specific options
Save custom model
ActiveRecord model
Using Gii generator
Using Debug panel
Using SqlDataProvider
Using Migration Data
convert schema mysql >>> clickhouse
create custom console controller
migration mysql,mssql data >>> clickhouse
create custom console controller
Result
ClickHouse Reference Manual
https://clickhouse.yandex/reference_en.html
Summary of recommendations insert data
- 1 Accumulated data and insert at one time, it will reduce the operations io disk
- 2 @todo how that will add...
Run tests
- 1 git clone repository
https://github.com/sanchezzzhak/kak-clickhouse.git
- 2
composer install --ignore-platform-reqs
-
3 create the config clickhouse
touch tests/_config/clickhouse.php
if you non-standard access to the server connection - 4 run tests
php vendor/bin/codecept run