Repository files navigation

Laravel ClickHouse database integration.This package includes generation and execution of the ClickHouse database migrations in the Laravel application.

• smi2/phpClickHouse client integration
• Migration creation
• Migration execution

Pull in the package throughComposer.

composer require cybercog/laravel-clickhouse

Add environment variables in.env file.

CLICKHOUSE_HOST=localhostCLICKHOUSE_PORT=8123CLICKHOUSE_USER=defaultCLICKHOUSE_PASSWORD=CLICKHOUSE_DATABASE=default

Publish ClickHouse configuration.

php artisan vendor:publish --provider="Cog\Laravel\Clickhouse\ClickhouseServiceProvider" --tag=config

Editconfig/clickhouse.php file.

You can use a singleton objectsmi2/phpClickHouse to query ClickHouse:

app(\ClickHouseDB\Client::class)->select(/* Query */);app(\ClickHouseDB\Client::class)->write(/* Query */);

php artisan make:clickhouse-migration create_example_table

New migration will be created indatabase/clickhouse-migrations directory.

php artisan clickhouse:migrate

To remove the interactive question during production migrations, you can use--force option.

php artisan clickhouse:migrate --force

You can specify how many files need to be applied:

php artisan clickhouse:migrate --step=1

Value0 is default — all files

Rolling back migrations is intentionally unavailable. Migrations should go only forward.

Detailed changes for each release are documented in theCHANGELOG.md.

• Laravel ClickHouse package is open-sourced software licensed under theMIT license byAnton Komarev.

CyberCog is a Social Unity of enthusiasts. Research the best solutions in product & software development is our passion.

• Follow us on Twitter