olegsv/history

This package put information about each request into clickhouse db

v1.0 2021-10-08 08:27 UTC

Requires

• php: >=7.1
• glushkovds/phpclickhouse-laravel: 1.10.0
• illuminate/routing: ^8.63
• illuminate/support: ^8.54
• laravel/ui: ^3.3

MIT

• Oleg Sviridov

README

1. Add ClickhouseServiceProvider into your config/app.php file, 'providers' section.

'providers' => [
  .......
  \PhpClickHouseLaravel\ClickhouseServiceProvider::class,
  .......

1. Publish package files

php artisan vendor:publish

1. Add connection for clickhouse into your config/database.php file.

        '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,
            ],
        ],

1. Run migration

php artisan migrate

1. Now you can see all requests to your server (use '/history' route).