Hello Mike,

To be honest, I have never really used PostgreSQL and not really sure how much adoption are there for PostgreSQL on Joomla. However, all of our database calls routes through the database api in Joomla and if there's a layer that handles these database calls, I believe it should work fine.

We are no longer using stored functions because it seems like not many hosting provider allows normal hosting accounts to use them.

That is perfect! Joomla 3 core does work flawlessly with PostgreSQL, but as always the main consideration is with 3rd parties. I have never used PostgreSQL myself either, but I've seen one deployed with an extension that uses the database adapter and it's works well. Crossing my fingers. Hopefully there's some EasySocial + PostGres user out there that can confirm this.

Hello Mike,

Hm, what was the main reason of using PostgreSQL eh? PostgreSQL isn't as popular as MySQL or MariaDB as far as I recall?

As of 9.3, PostgreSQL is now an RDBMS/NoSQL hybrid. So if you need certain advantages of NoSQL (eg if you have a mobile platform with massive transactional volume) then PostgreSQL is the much better option.

Ah, I see. Thanks for the heads up on this Mike

and so, is it working ?

Hi Meyrou,

We haven't tested install EasySocial on a PostgreSQL database but if Joomla already support PostgreSQL, then I believe EasySocial will work fine in PostgreSQL as we are calling Joomla db's API

Hope this help and have a nice day!

you should test it and validate it, since joomla is postgre compliant, and you are selling your extensions.
i ordered your extensions and now can't use it : it won't simply install themsleves on a J3.4 PGSQL server.

Hello Meyrou,

Most of our SQL queries are being wrapped through Joomla's database query and if these database wrapper works with postgresql, it should work too.

but it's not :

or :

Hi Meyrou,

Thanks for verifying this for us. Look like EasyBlog hardcoded some of the column escaping characters to MySQL format. We will go through all the SQL statement again and we will make sure all the escape character will be handle by Joomla api

Thank and have a nice day!