PHPackages                             glushkovds/phpclickhouse-laravel - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. glushkovds/phpclickhouse-laravel

ActiveLibrary[Database & ORM](/categories/database)

glushkovds/phpclickhouse-laravel
================================

Adapter of the most popular library https://github.com/smi2/phpClickHouse to Laravel

v2.5.2(1mo ago)2031.2M↓12.3%49[3 issues](https://github.com/glushkovds/phpclickhouse-laravel/issues)2MITPHPPHP >=8.0CI passing

Since Sep 16Pushed 1mo ago4 watchersCompare

[ Source](https://github.com/glushkovds/phpclickhouse-laravel)[ Packagist](https://packagist.org/packages/glushkovds/phpclickhouse-laravel)[ Docs](https://github.com/glushkovds/phpClickHouse-laravel)[ RSS](/packages/glushkovds-phpclickhouse-laravel/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)Dependencies (14)Versions (59)Used By (2)

[![Tests](https://github.com/glushkovds/phpclickhouse-laravel/actions/workflows/test.yml/badge.svg)](https://github.com/glushkovds/phpclickhouse-laravel/actions/workflows/test.yml/badge.svg)

phpClickHouse-laravel
=====================

[](#phpclickhouse-laravel)

Adapter to Laravel and Lumen of the most popular libraries:

-  - for connections and perform queries
-  - good query builder

Features
--------

[](#features)

No dependency, only Curl (support php >=8.0 )

More:

Prerequisites
-------------

[](#prerequisites)

- PHP 8.0
- Laravel/Lumen 7+
- Clickhouse server

Installation
------------

[](#installation)

**1.** Install via composer

```
$ composer require glushkovds/phpclickhouse-laravel
```

**2.** Add new connection into your config/database.php:

```
'clickhouse' => [
    'driver' => 'clickhouse',
    'host' => env('CLICKHOUSE_HOST'),
    'port' => env('CLICKHOUSE_PORT','8123'),
    'database' => env('CLICKHOUSE_DATABASE','default'),
    'username' => env('CLICKHOUSE_USERNAME','default'),
    'password' => env('CLICKHOUSE_PASSWORD',''),
    'timeout_connect' => env('CLICKHOUSE_TIMEOUT_CONNECT',2),
    'timeout_query' => env('CLICKHOUSE_TIMEOUT_QUERY',2),
    'https' => (bool)env('CLICKHOUSE_HTTPS', null),
    'retries' => env('CLICKHOUSE_RETRIES', 0),
    'settings' => [ // optional
        'max_partitions_per_insert_block' => 300,
    ],
    'fix_default_query_builder' => true,
],
```

Then patch your .env:

```
CLICKHOUSE_HOST=localhost
CLICKHOUSE_PORT=8123
CLICKHOUSE_DATABASE=default
CLICKHOUSE_USERNAME=default
CLICKHOUSE_PASSWORD=
CLICKHOUSE_TIMEOUT_CONNECT=2
CLICKHOUSE_TIMEOUT_QUERY=2
# only if you use https connection
CLICKHOUSE_HTTPS=true
```

**3.** Add service provider into your config/app.php (bootstrap/providers.php for Laravel 11+) file providers section:

```
\PhpClickHouseLaravel\ClickhouseServiceProvider::class,
```

It should be placed *before* App\\Providers\\AppServiceProvider::class, and App\\Providers\\EventServiceProvider::class.

Usage
-----

[](#usage)

You can use smi2/phpClickHouse functionality directly:

```
/** @var \ClickHouseDB\Client $db */
$db = DB::connection('clickhouse')->getClient();
$statement = $db->select('SELECT * FROM summing_url_views LIMIT 2');
```

More about `$db` see here:

#### Or use dawnings of Eloquent ORM (will be implemented completely)

[](#or-use-dawnings-of-eloquent-orm-will-be-implemented-completely)

**1.** Add model

```