fwolfsjaeger/doctrine-cockroachdb-bundle

Doctrine DBAL CockroachDB Driver Bundle for Symfony

0.9.0 2024-04-11 17:58 UTC

Requires

• php: ^8.0
• doctrine/doctrine-bundle: ^2.10|^2.11|^2.12
• fwolfsjaeger/doctrine-cockroachdb: ^0.8|^0.9
• symfony/dependency-injection: ^6.0|^6.1|^6.2|^6.3|^6.4|^7.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.41
• phpstan/phpstan: ^1.10
• phpstan/phpstan-strict-rules: ^1.5
• phpstan/phpstan-symfony: ^1.3
• roave/security-advisories: dev-latest
• squizlabs/php_codesniffer: ^3.7

MIT

• Florian Wolfsjaeger

• symfony
• doctrine
• pdo
• cockroach
• cockroachdb
• pdo_pgsql
• doctrine-cockroachdb
• doctrine-cockroachdb-bundle

README

CockroachDB Driver Bundle for Symfony

CockroachDB Driver is a Doctrine DBAL Driver to handle incompatibilities with PostgreSQL. This package is meant to be used with (and requires) Symfony 6.0 or newer.

It is based on https://github.com/lapaygroup/doctrine-cockroachdb by Lapay Group.

CockroachDB Quick Setup Guide

• Linux Setup Guide
• Mac Setup Guide
• Windows Setup Guide

Usage

Connection configuration example using a DSN

# doctrine.yaml
doctrine:
    dbal:
        url: crdb://<user>@<host>:<port(26257)>/<dbname>?sslmode=verify-full&sslrootcert=<path-to-ca.crt>&sslcert=<path-to-user.crt>&sslkey=<path-to-user.key>

Alternative: YAML connection configuration example

# doctrine.yaml
doctrine:
    dbal:
        user: <user>
        port: <port(26257)>
        host: <host>
        dbname: <dbname>
        sslmode: verify-full
        sslrootcert: <path-to-ca.crt>
        sslcert: <path-to-user.crt>
        sslkey: <path-to-user.key>
        driver: crdb

License

MIT