Like PostgreSQL and want to use it with SugarCRM? Check out a new community project!

sugarcrmdevelopers —  August 3, 2012 — 21 Comments

If you remember with the SugarCRM 6.4 release, one of the big goals we had with the database refactor it was to make it easier for building out new database backends by only needing to change the code at the driver level itself. With this we added DB2 support to the Enterprise edition of Sugar, and also made a call to the community to build out new backends to help Sugar run on more and more databases.

One developer has taken that charge. Antonio Musarra is a freelance developer from Italy who has did a fork of Sugar on GitHub to add PostgreSQL support to it, only adding the new DB drivers and not having to make any core changes to the app. He is also providing us great feedback in the process, letting us know of any bugs along the way he is seeing to make sure the fork is successful.

With any community project like this, many wonder if this is something we’d be interesting in having the core Sugar application. Is Postgres something you’d use in Sugar, or do you have a client that would love to be able to use PostgreSQL instead of MySQL. Let us know in the comments and vote on this bug to show your interest and support.

21 responses to Like PostgreSQL and want to use it with SugarCRM? Check out a new community project!

  1. 

    This is great! Would love to see PostgreSQL support added to the core please 🙂

  2. 

    Yep, vastly superior DB..lets have this

  3. 

    Yes please!

  4. 

    Thanks John for the post on my work.
    I would like to remind everyone that on the Wiki at GitHub, describes the QuickStart https://github.com/amusarra/sugarcrm_dev_PostgreSQL/wiki/PostgreSQL-Driver

    Bye,
    Antonio M.

  5. 

    Hi everyone,
    at http://susestudio.com/a/2Vav5p/sugarcrm-ce-6-4-postgresql find the virtual machine that I made with SugarCRM CE 4.6 + PostgreSQL

    Bye,
    Antonio.

  6. 

    Hi everyone,
    I just installed SugarCRM CE 6.5 + PostgreSQL 8.4, now the PHP IMAP module is supported by OpenShift. The URL of the application is http://sugarcrmpgsql-shiruslabs.rhcloud.com/. Username and password is: admin/admin. I use the community build of Sugar with Postgres.Bye,Antonio. 

  7. 

    Core support of postgreSQL would be awesome. +1

  8. 
    Craig Ringer (2ndQuadrant) November 5, 2012 at 10:48 pm

    I voted on the bug but it takes *minutes* just to load. It then takes another couple of minutes to log in, and after login I’m not redirected back to where I was so I have to search for the bug by bug number. This search also takes a long time, as does re-loading the bug now that I’m logged in.

    Perhaps you’re running very heavy database maintenance at this time (11:45 am, +08:00 time)? It’s hard to imagine that the issue tracker always performs this poorly, but it was just as slow when I tried yesterday.

    I wonder how many others would’ve liked to vote, but didn’t because it took so long?

  9. 

    Good news! I am working on a vertical solution for municipalities based on Sugar… and some of the people there is objecting it’s use because of MySQL… so, is what I was looking for! cloning now…

  10. 

    I have great preferences to Postgresql and switches MySQL to Postgresql when and wherever I can. I actually prefer software that use Postgresql above software that is mysql only.

      • 

        Hi Antonio,

        Congrats for the great work!
        I have been installing the copy of your “Sugar on GitHub to add PostgreSQL” on my local machine. I am getting error “Fatal error: Maximum execution time of 300 seconds exceeded in C:\mypath\jssource\Minifier.php on line 178” Though I increased the max_execution_time to 4000.

        Please help me in that.

        Thanks in Anticipation

Trackbacks and Pingbacks:

  1. Virtual Appliance SugarCRM + PostgreSQL « Antonio Musarra's Blog - August 3, 2012

    […] Like PostgreSQL and want to use it with SugarCRM? Check out a new community project! -Post scritto da John Mertic sul Developers Blog di SugarCRM […]

  2. SugarCRM Virtual Appliance + PostgreSQL « Antonio Musarra's Blog - August 7, 2012

    […] Like PostgreSQL and want to use it with SugarCRM? Check out a new community project! -Post written by John Mertic on SugarCRM Developers Blog […]

  3. SugarCRM + PostgreSQL disponibile su OpenShift « Antonio Musarra's Blog - August 7, 2012

    […] giorni scorsi John Mertic ha pubblicato con un post sul blog di SugarCRM, il rilascio del driver PostgreSQL per SugarCRM Community Edition. Il source tree di SugarCRM CE completo dei driver è disponibile sul mio repository GitHub […]

  4. SugarCRM + PostgreSQL available OpenShift « Antonio Musarra's Blog - August 11, 2012

    […] 0 A few days ago, John Mertic has published a blog post of SugarCRM, the release of the driver PostgreSQL for SugarCRM Community Edition . The complete source tree is available on my GitHub repository […]

  5. Released new version of SugarCRM PostgreSQL Virtual Appliance « Antonio Musarra's Blog - August 30, 2012

    […] Like PostgreSQL and want to use it with SugarCRM? Check out a new community project! -Post written by John Mertic on SugarCRM Developers Blog […]

  6. is SugarCRM valid for a million contacts - March 20, 2013

    […] […]

  7. Vote to add PostgreSQL database support to SugarCRM CE - April 10, 2013

    […] […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s