lapaygroup/doctrine-cockroachdb

Doctrine CockroachDB Driver (Symfony supports)

0.2.0 2021-08-01 12:35 UTC

Requires

• php: ^7.2 || ^8.0
• ext-pdo: *
• doctrine/dbal: ^2.10 || ^3.0

MIT

• Dolf Schimmel
• Nikolay Lapay

• doctrine
• pdo
• cockroach
• cockroachdb
• pdo_pgsql
• doctrine-cockroachdb

README

CockroachDB Driver

Driver for supports CockroachDB in Doctrine DBAL. This library fixes errors related doctrine:migrations when using PostgreSQL driver.

Serverless connection URL format: //clouduser:[e-mail]:26257/clustername.dbname

Symfony configuration example:

# doctrine.yaml
doctrine:
    dbal:
        user: root
        port: 26257
        host: localhost
        dbname: database_name
        platform_service: LapayGroup\DoctrineCockroach\Platforms\CockroachPlatform
        driver_class: LapayGroup\DoctrineCockroach\Driver\CockroachDriver
        
    # Serverless example
    dbal:
        user: wildtuna
        password: password
        port: 26257
        host: free-tier7.aws-eu-west-1.cockroachlabs.cloud
        dbname: lapaygroup-test-869.defaultdb
        platform_service: LapayGroup\DoctrineCockroach\Platforms\CockroachPlatform
        driver_class: LapayGroup\DoctrineCockroach\Driver\CockroachDriver

Connection url style:

# doctrine.yaml
doctrine:
    dbal:
        url: //root:@localhost:26257/database_name
        platform_service: LapayGroup\DoctrineCockroach\Platforms\CockroachPlatform
        driver_class: LapayGroup\DoctrineCockroach\Driver\CockroachDriver
        
    # Serverless example    
    dbal:
        url: '//wildtuna:[e-mail]:26257/lapaygroup-test-869.defaultdb'
        platform_service: LapayGroup\DoctrineCockroach\Platforms\CockroachPlatform
        driver_class: LapayGroup\DoctrineCockroach\Driver\CockroachDriver     

# services.yaml
services:
  LapayGroup\DoctrineCockroach\Platforms\CockroachPlatform:
    autowire: true

  LapayGroup\DoctrineCockroach\Driver\CockroachDriver:
    autowire: true

  LapayGroup\DoctrineCockroach\Schema\CockroachSchemaManager:
    autowire: true