smi2/phpClickHouse
A PHP wrapper for ClickHouse providing asynchronous queries, bulk inserts, cluster management, and performance optimizations for efficient database interaction.
cybercog/laravel-clickhouse
Laravel ClickHouse is a package designed to integrate the ClickHouse database with Laravel applications, providing seamless client integration and support for generating and executing ClickHouse database migrations. This package leverages the smi2/phpClickHouse client to enable querying and writing operations directly from Laravel, making it easier for developers to work with ClickHouse within the Laravel ecosystem. The package offers several key features including the creation and execution of database migrations specifically for ClickHouse, allowing developers to manage their database schema changes efficiently. Migrations are created using artisan commands and stored in a dedicated directory, facilitating organized and version-controlled database changes. The package supports running migrations with options to specify the number of migration files to apply and includes a force option to bypass interactive prompts during production deployments. One notable aspect of Laravel ClickHouse is that it intentionally does not support rolling back migrations, emphasizing a forward-only migration strategy. This design choice aligns with the nature of ClickHouse and encourages careful planning of schema changes. Installation is straightforward via Composer, and configuration is managed through environment variables and a published configuration file, allowing customization of connection parameters such as host, port, user credentials, and database name. The package is open-source and licensed under the MIT license, maintained by Anton Komarev and the CyberCog community. Overall, Laravel ClickHouse simplifies the integration of ClickHouse into Laravel projects by providing essential tools for database interaction and migration management, making it a valuable resource for developers looking to leverage ClickHouse's capabilities within a Laravel framework.
https://github.com/cybercog/laravel-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.
FriendsOfDoctrine/dbal-clickhouse
Doctrine DBAL driver for ClickHouse database enabling seamless integration with Symfony and other frameworks using Doctrine, supporting advanced database operations and custom types.