Is there a version of CiviCRM that's compatible with Postgres and Wordpress?
-
Are you looking to run Civi-on-Postgres -- or to integrate Civi with (WordPress-on-Postgres). Although Civi puts its own tables in MySQL, it should be agnostic about the WordPress tables (modulo a few small patches/workarounds).– Tim OttenSep 12, 2015 at 18:44
Add a comment
|
1 Answer
No.
CiviCRM uses MySQL functions extensively, so it can't be run with PostgreSQL.
This has been raised before over on forum.civicrm.org (at least in 2010 and 2007). Tim Otten's answer in this forum post may also help understand some of the workings currently in the DB layer (and specific to MySQL).
It could (in theory) be done, but it would take significant effort and leadership from the community who wanted to make it happen.
-
On reflection I feel confident those mysqlisms could be implemented in pg - but you'd have a high maintenance undertaking, and a small group of users to start with. Sep 11, 2015 at 18:21
-
It's a relatively new project, but it seems to me that over the long haul it would be of great benefit to the users to have PostgreSQL as an option for CiviCRM, simply because of how much data PostgreSQL can hold.– leeand00Sep 11, 2015 at 18:52
-
I agree - I'm not a big fan of CiviCRM's MySQLism, but it's the status quo. Similar to the situation on WordPress, but with a much larger codebase and smaller pool of organisations to fund the work. Sep 11, 2015 at 20:11
-
If DB size limits are your concern, it's likely to be less work for you to contribute towards optimising CiviCRM on MySQL. MySQL can also handle significant data sets. Sep 11, 2015 at 20:12
-
2I know a developer who's been working toward this as a side-project, although he hasn't published anything. If anyone is looking to collaborate on or fund such a project, email info-at-civicrm.org and I'll put you in touch. Sep 12, 2015 at 18:29