Download the PHP package brlabrussia/dbal-clickhouse without Composer
On this page you can find all versions of the php package brlabrussia/dbal-clickhouse. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download brlabrussia/dbal-clickhouse
More information about brlabrussia/dbal-clickhouse
Files in brlabrussia/dbal-clickhouse
Package dbal-clickhouse
Short Description Doctrine DBAL driver for ClickHouse
License MIT
Homepage https://github.com/brlabrussia/dbalClickhouse
Informations about the package dbal-clickhouse
Doctrine DBAL ClickHouse Driver
Doctrine DBAL driver for ClickHouse -- an open-source column-oriented database management system by Yandex (https://clickhouse.yandex/)
Driver is suitable for Symfony or any other framework using Doctrine.
Installation
Initialization
Custom PHP script
driverOptions
are special smi2/phpclickhouse
client settings
Symfony
configure...
...and get from the service container
Usage
Create new table
Insert
Select
Select via Dynamic Parameters and Prepared Statements
Additional types
If you want to use Array(T) type, register additional DBAL types in your code:
or register them in Symfony configuration file:
Additional type BigIntType
helps you to store bigint values as Int64/UInt64 value type in ClickHouse.
You can override DBAL type in your code:
or use custom mapping types in Symfony configuration:
More information in Doctrine DBAL documentation:
Doctrine Entity Manager
Основные потребности в бандле
- возможность работы с таблицами ClickHouse и библиотекой dbal-clickhouse
- возможность задавать аннотации подобно ORM/Doctrine
- возможность единой схемы создания таблиц из аннотаций
- возможность вставки и выборки данных без задания явных запросов
- поддержка миграций
- nullable работает для всех типов
Аннотация таблиц
unique=true служит для обозначения первичных ключей. В clickhouse нет уникальных полей
All versions of dbal-clickhouse with dependencies
ext-pdo Version *
ext-pcre Version *
doctrine/dbal Version ^2.7
smi2/phpclickhouse Version ^1.0
doctrine/orm Version ^2.5
doctrine/doctrine-bundle Version ^1.6
doctrine/doctrine-cache-bundle Version ^1.2