PHPackages                             allesx/laravel-clickhouse - 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. allesx/laravel-clickhouse

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

allesx/laravel-clickhouse
=========================

Eloquent model for ClickHouse

3.0.0(4y ago)23351MITPHPPHP >=7.1

Since Jul 9Pushed 4y agoCompare

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

READMEChangelog (1)Dependencies (6)Versions (9)Used By (0)

Laravel Clickhouse
==================

[](#laravel-clickhouse)

[![Latest Stable Version](https://camo.githubusercontent.com/2a197847c03e6e0e8dc1c3bb58e7acab5117fa67f959e527841c970afebdc36a/68747470733a2f2f706f7365722e707567782e6f72672f616c6c6573782f6c61726176656c2d636c69636b686f7573652f762f737461626c65)](https://packagist.org/packages/allesx/laravel-clickhouse)[![Latest Unstable Version](https://camo.githubusercontent.com/c6ccddd6d73519dc7e772639e76b9ee1046bc46c83f291b6481177557ef9bb61/68747470733a2f2f706f7365722e707567782e6f72672f616c6c6573782f6c61726176656c2d636c69636b686f7573652f762f756e737461626c65)](https://packagist.org/packages/allesx/laravel-clickhouse)[![License](https://camo.githubusercontent.com/0bf27a37423ed8251cbddd4839b9ed9bb95b477970b56b3062fbffcb5365b6f3/68747470733a2f2f706f7365722e707567782e6f72672f616c6c6573782f6c61726176656c2d636c69636b686f7573652f6c6963656e7365)](https://packagist.org/packages/allesx/laravel-clickhouse)[![composer.lock](https://camo.githubusercontent.com/c94bc38c10f908be28138e2692ecf30492ce4a1e8e7628e007dd2b521123fac7/68747470733a2f2f706f7365722e707567782e6f72672f616c6c6573782f6c61726176656c2d636c69636b686f7573652f636f6d706f7365726c6f636b)](https://packagist.org/packages/allesx/laravel-clickhouse)

Laravel Clickhouse - Eloquent model for ClickHouse.

- **Vendor**: allesx
- **Package**: Laravel Clickhouse
- **Version**: [![Latest Stable Version](https://camo.githubusercontent.com/2a197847c03e6e0e8dc1c3bb58e7acab5117fa67f959e527841c970afebdc36a/68747470733a2f2f706f7365722e707567782e6f72672f616c6c6573782f6c61726176656c2d636c69636b686f7573652f762f737461626c65)](https://packagist.org/packages/allesx/laravel-clickhouse)
- **Laravel Version**: `5.8.x`
- **PHP Version**: 7.1.3+
- **[Composer](https://getcomposer.org/):** `composer require allesx/laravel-clickhouse`

Get started
-----------

[](#get-started)

```
$ composer require allesx/laravel-clickhouse
```

Then add the code above into your config/app.php file providers section

```
Allesx\LaravelClickHouse\ClickHouseServiceProvider::class,
```

And add new connection into your config/database.php file. Something like this:

```
'connections' => [
    'allesx::clickhouse' => [
        'driver' => 'allesx::clickhouse',
        'host' => '',
        'port' => '',
        'database' => '',
        'username' => '',
        'password' => '',
        'options' => [
            'timeout' => 10,
            'protocol' => 'https'
        ]
    ]
]
```

Or like this, if clickhouse runs in cluster

```
'connections' => [
    'allesx::clickhouse' => [
        'driver' => 'allesx::clickhouse',
        'servers' => [
            [
                'host' => 'ch-00.domain.com',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ],
            [
                'host' => 'ch-01.domain.com',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ]
        ]
    ]
],
```

Then create model

```