Using Postgresql Database

[nurwin]

Hi.. I have laravel application that run with pgsql database. is it possible to using it? in aws I will use RDS. how to integrate with it?

Thanks in advice.

[wysow]

Sure you should be able to use your RDS database with the same parameters as you would do on an EC2 instance. Just use the security groups like always.

[nurwin]

yes, when I run it, the apps return "error could not find driver", is bref support pgsql database?

[nurwin]

should I modify the dockerfile on vendor?

[wysow]

Hum... You're right, we should compile the pgsql driver for php to be used in bref.

[nurwin]

@mnapoli would you like to add enhancement for this issue? thank you

[mnapoli]

@nurwin I do not need that at the moment so I will not work on that. However feel free to send a pull request to add PostgreSQL support, that would be great!

[davidavz]

You just have to add the --with-pdo-pgsql into the Dockerfile isn't it?

[mnapoli]

I think so, I have never used it so I'm not 100% sure if it needs other dependencies though.

[thiagomarini]

Need to add RUN yum install postgresql-devel -y before --with-pdo-pgsql

[thiagomarini]

I've compiled a PHP binary with MySQL and Postgres if anyone wants it:

https://s3-eu-west-1.amazonaws.com/assets.weengs.com/php-7.2.5.tar.gz

Just place it inside .bref/bin/php folder and Bref won't overwrite it on deploy

[mnapoli]

The PostgreSQL extension is available in v0.3 (see https://bref.sh/docs/environment/php.html to enable it) 🎉

[nurwin]

Thanks @mnapoli