Re: CRM where pg is a first class citizen?

On 12/13/2016 09:36 PM, George Weaver wrote:
> I've never used it but what about:
>
> https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/

That's one of the first thing I've read and it doesn't look as a good
premise to make pg a first class citizen.

BTW

Joshua D. Drake cited Drupal 7+

Drupal was the reason I started using postgres back in the days and it
has been one of the reasons I was bothering you all on this list more
frequently few years ago.

I've spent a pretty huge amount of time locally patching Drupal to make
it work with postgresql and to try to push some of the patches upstream.

I don't develop on Drupal anymore but up to at least D7 Postgresql was
still not a first class citizen.

I've heard DB abstraction layer in D8 is much better but I don't have
anything critical on Drupal anymore and life is too short to fight to
see your patches refused from upstream because "supporting postgres is
holding us back".
Considering that most PHP web applications are not optimized for any DB
and I wonder what features could a developer exploit to optimize for
mysql, that's really a shame.

I don't want to repeat the experience, especially on software I'm just
going to use and not develop on.

Forgive me for I have sinned: last Drupal I've installed was 7 and I
picked up mysql and I still feel awkward when I've to deal with it.

I'm using horde on postgres. Postgres is not a first class citizen in
Horde but at least they were happy and quick to merge a couple of my
patches.

Working with pg was fun, it was a very nice piece of software, it has a
great community and it got even better.
I'm not anymore a hardcore user but I still enjoy using it.

There are much more services offering Postgres on the internet (Amazon,
Heroku, OpenStack...).
Lack of proper support from "web applications" still drives me nuts.

It comes to no surprise that Python and Java "web applications" tend to
support postgres better.
Python would be absolutely welcome, but I don't have that much
experience managing Java on the web.

https://www.odoo.com/ supports postgres but it is an ERP and it is far
more complicated than I would like.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net