Re: Which CMS/Ecommerce/Shopping cart ?

This touches on a question I would love to be able to answer

Why is MySQL so much more popular right now, especially in the OpenSource community? As a database I find its architecture with multiple underlying engines and other quirks to be rather dubious. Then there is the issue of commercial licenses and exactly when you must have those and what it will really cost. Yet it is pretty ubiquitous. How come? Why isn't postgresql more on developer's minds when they think of OS databases? Amazon cloud has great scalable MySQL support but apparently not postgreql. Why? Is there something about postgresql that is bugging all these people or what?

- samantha

On Jul 29, 2010, at 10:16 AM, Ivan Sergio Borgonovo wrote:

> On Thu, 29 Jul 2010 08:52:46 -0700
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
>
>> The issue isn't Drupal. It is modules. There are a lot of popular
>> modules that do not work with PostgreSQL (Lightbox for example).
>
>> The google checkout module for Ubercart didn't work either until
>> relatively recently.
>
> I'd say the opposite but I'll wait to test more D7.
> Core takes ages to agree on what should be done to fix bugs for
> Postgres without affecting even the "feelings" of MySQL developers.
>
> Modules may have more problems but fixing them is generally trivial
> and generally upstream is quick to integrate the fix.
>
> The problem for core is maintaining your patches till and if they
> fix the bug.
>
> I agree that PHP and MySQL are a perverse match.
>
> Still if he plans to deploy stuff as "commodity" software they are a
> necessary evil.
> The problem arise when you're in-between custom and RAD.
> Anyway more python/django based cms are flourishing... and given
> Django originally supported DB was Postgres...
> http://www.django-cms.org/ [1]
>
> Migration of Onion from Drupal/Mysql -> Django/Postgresql is
> emblematic.
>
> [1] I think I could make a quick benchmark if possible on postgresql
> and mysql
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general