smi2/phpClickHouse
A PHP wrapper for ClickHouse providing asynchronous queries, bulk inserts, cluster management, and performance optimizations for efficient database interaction.
FriendsOfDoctrine/dbal-clickhouse
The project FriendsOfDoctrine/dbal-clickhouse is a Doctrine DBAL driver specifically designed for the ClickHouse database, an open-source column-oriented database management system developed by Yandex. This driver integrates seamlessly with Symfony and other frameworks that utilize Doctrine, providing a robust and efficient way to interact with ClickHouse databases. The project supports multiple versions of Doctrine DBAL and PHP, ensuring compatibility with a wide range of environments. Version 3 supports Doctrine DBAL 4+ and PHP 8.1+, version 2 supports Doctrine DBAL 3+ and PHP 8.0+, and version 1 supports Doctrine DBAL 2+ and PHP 7.1+. Installation is straightforward via Composer, and the driver can be initialized either through custom PHP scripts or Symfony configuration files. The driver offers extensive configuration options, including connection parameters and driver-specific settings such as extremes, readonly mode, max execution time, HTTP compression, and HTTPS usage. It supports essential database operations like creating databases and tables, inserting data, and executing complex queries with prepared statements and dynamic parameters. The driver also allows for advanced table configurations, including specifying table engines, partitioning columns, sampling expressions, and index granularity. Additionally, it supports custom DBAL types for ClickHouse's array data types, enhancing its flexibility and usability. This project is well-suited for developers looking to leverage the power of ClickHouse within the Doctrine ecosystem, providing a familiar and efficient interface for database interactions. It is actively maintained, with continuous integration for testing and code style checks, and is available under an open-source license. Overall, FriendsOfDoctrine/dbal-clickhouse bridges the gap between Doctrine's database abstraction layer and ClickHouse's high-performance analytical database capabilities, making it an invaluable tool for PHP developers working with large-scale data analytics and real-time data processing.
https://github.com/FriendsOfDoctrine/dbal-clickhouse
Also in PHP
the-tinderbox/ClickhouseBuilder
ClickhouseBuilder is a PHP fluent query builder designed to simplify the construction and execution of complex SQL queries for Clickhouse databases, with integration support for Laravel and Lumen frameworks.
cybercog/laravel-clickhouse
Laravel ClickHouse is a package that integrates ClickHouse database client and migration support into Laravel applications, enabling efficient management of ClickHouse databases within the Laravel framework.