2017 © Pedro Peláez
 

library laravel-clickhouse

Clickhouse Laravel package

image

libern/laravel-clickhouse

Clickhouse Laravel package

  • Monday, June 11, 2018
  • by libern
  • Repository
  • 1 Watchers
  • 0 Stars
  • 27 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 9 Forks
  • 0 Open issues
  • 14 Versions
  • 0 % Grown

The README.md

laravel-clickhouse

Eloquent model for ClickHouse, (*1)

Prerequisites

  • php 7.1
  • clickhouse server

Installation

$ composer require libern/laravel-clickhouse

Then add the code above into your config/app.php file providers section, (*2)

Libern\LaravelClickHouse\ClickHouseServiceProvider::class,

And add new connection into your config/database.php file. Something like this:, (*3)

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

Or like this, if clickhouse runs in cluster, (*4)

'connections' => [
    'clickhouse' => [
        'driver' => 'clickhouse',
        'cluster' => [
            'server-1' => [
                'host' => '',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ],
            'server-2' => [
                'host' => '',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ]
        ]
    ]
]

Then create model, (*5)

<?php

use Libern\LaravelClickHouse\Database\Eloquent\Model;

class Payment extends Model
{
    protected $table = 'payments';
}

And use it, (*6)

Payment::select(raw('count() AS cnt'), 'payment_system')
    ->whereBetween('payed_at', [
        Carbon\Carbon::parse('2017-01-01'),
        now(),
    ])
    ->groupBy('payment_system')
    ->get();

Roadmap

  • more tests
  • Model::with() method
  • relations

The Versions

11/06 2018

dev-master

9999999-dev

Clickhouse Laravel package

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

11/06 2018

1.2.4

1.2.4.0

Clickhouse Laravel package

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

06/06 2018

1.2.3

1.2.3.0

Clickhouse Laravel package

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

06/06 2018

1.2.2

1.2.2.0

Clickhouse Laravel package

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

06/06 2018

1.2.1

1.2.1.0

Clikhouse

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

01/05 2018

1.1.1

1.1.1.0

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

25/04 2018

1.1.0

1.1.0.0

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

25/04 2018

1.0.2

1.0.2.0

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

25/04 2018

1.0.1

1.0.1.0

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

23/04 2018

1.0.0

1.0.0.0

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

21/12 2017

dev-analysis-8nlQP1

dev-analysis-8nlQP1

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

21/12 2017

dev-analysis-8mB6PY

dev-analysis-8mB6PY

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

15/12 2017

dev-analysis-qJ7E6D

dev-analysis-qJ7E6D

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse

13/12 2017

dev-analysis-qJ7b9E

dev-analysis-qJ7b9E

  Sources   Download

MIT

The Requires

 

The Development Requires

laravel eloquent clickhouse