nordicalf/clickhouse-doctrine

Doctrine DBAL driver for ClickHouse

v1.0.4 2022-02-23 12:07 UTC

Requires

• php: ^7.3 || ^8.0
• ext-pcre: *
• ext-pdo: *
• doctrine/dbal: ^3.2
• smi2/phpclickhouse: ^1.4

Requires (Dev)

• doctrine/coding-standard: ^9.0
• phpunit/phpunit: ^9.0

MIT

• dbal
• doctrine
• driver
• clickhouse

README

Installation

composer require nordicalf/clickhouse-doctrine

Initialization

# .env
###< clickhouse ###>
CLICKHOUSE_IP=127.0.0.1
CLICKHOUSE_DB=your_db
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=your_password
CLICKHOUSE_PORT=8123
CLICKHOUSE_CONSOLE_PORT=9000

Symfony

configure...

# app/config/packages/doctrine.yml
doctrine:
  dbal:
    default_connection: default
    connections:
      default:
        url: '%env(resolve:DATABASE_URL)%'
      clickhouse:
        host: '%env(resolve:CLICKHOUSE_IP)%'
        port: '%env(resolve:CLICKHOUSE_PORT)%'
        user: '%env(resolve:CLICKHOUSE_USER)%'
        password: '%env(resolve:CLICKHOUSE_PASSWORD)%'
        dbname: '%env(resolve:CLICKHOUSE_DB)%'
        driver_class: ClickhouseDoctrine\Driver
        wrapper_class: ClickhouseDoctrine\Connection
        options:
          enable_http_compression: 1
          max_execution_time: 60

...and get from the service container

$conn = $this->get('doctrine.dbal.clickhouse_connection');