library flex-doctrine-pg

shorock/flex-doctrine-pg

Open minded PostGres connection driver for Doctrine DBAL

A little Doctrine DBAL driver for PostgreSQL connections. Basically, we've taken to using certain options in the libpq library that Doctrine's built in DSN constructor is opinionated about. Notably, sslcert or service, whereby we can use a different SSL certificate for cert authentication to Postgres. (BTW - if you just have one cert/key per user, they can just use the canon name of ~/.postgresql/server.crt, server.key, & root.crt and you don't need this module., _(*1)

If you've never used 'service', it's a lovely way to go. You can also do your command line connection with $ psql service=mydb if you set that up., _(*2)

Now, if you're using Doctrine more directly, the fact that it can't handle some of these advanced configuration options isn't such a problem. Write your options into new PDO(...) and pass it to Doctrine. Not so easy if you're wanting to use something higher level (Symfony, etc)., _(*3)

I'm pulling from the driverOptions array for bare Doctrine DBAL because I didn't want to add more options to the Symfony Doctrine bundle's top-level configuration schema., _(*4)

Example (Symfony - config.yml)

doctrine:
    dbal:
      driver_class: Shorock\Doctrine\FlexPDOPgSql\Driver
      user: shorock
      options:
        service: libdb
    # or
    # dsn: "pgsql:dbname=libdb.you.edu sslcert=/etc/pki/alternate.crt sslkey=/etc/pki/alternate.key"