CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • PostgreSQL support?
Pages: [1]

Author Topic: PostgreSQL support?  (Read 2409 times)

louisb

  • Guest
PostgreSQL support?
September 01, 2007, 08:05:54 pm
Hello,

I hope this isn't a FAQ... Is there any work under way to use PostgreSQL instead of MySQL as the constituency database? How much work would be involved? Is there a DB abstraction layer like Pear DB?

Thanks
 --Louis

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: PostgreSQL support?
September 02, 2007, 12:28:52 am

We use PEAR DB and PEAR DB_DataObject but in quite a few places we do a direct query (via PEAR DB / DataObject). Support for PostgreSQL will have to be built and supported by the community. We do not have the resources or expertise to support it at this stage. However aiming to support this for 2.0 is a good goal and we will make changes to core to accomodate it

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

louisb

  • Guest
Re: PostgreSQL support?
September 02, 2007, 05:54:52 am
How would you suggest I proceed? Are you at a stage of development that you could accept patches migrating from direct queries to Pear DB? Where's a good place to start that won't gorp the works if it's bad coding? So many questions... Thanks for your patience!
 --Louis

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: PostgreSQL support?
September 02, 2007, 11:56:27 am

Louis:

how much time do you have? is there a deadline? IMO, this is a fairly long involved procedure. I would recommend workng on CiviCRM v2.0 and above only since we are making significant changes to the DB there. You might want to read the foll:

http://civicrm.org/architecture/
http://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+from+subversion+%28SVN%29+repository
http://civicrm.org/blog/

http://pear.php.net/manual/en/package.database.php

and check the man pages for DB and DB_DataObject

note that we generate the schema and base access objects (DAO) from an xml file

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

louisb

  • Guest
Re: PostgreSQL support?
October 10, 2007, 08:41:34 pm
Hi,

Thanks for the references. I'll start reading and experimenting. No, this is not urgent, but it would be nice to support PostgreSQL -- it's a personal preference of mine.
 --Louis

dhruvahuja

  • Guest
Re: PostgreSQL support?
June 07, 2010, 01:30:36 pm
Interested members may look at http://forum.civicrm.org/index.php/topic,14103.0.html for my experiment with PostgreSQL.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • PostgreSQL support?

This forum was archived on 2017-11-26.