Re: Which CMS/Ecommerce/Shopping cart ? - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: Which CMS/Ecommerce/Shopping cart ?
Date
Msg-id 20100729105217.721b0fba@dawn.webthatworks.it
Whole thread Raw
In response to Re: Which CMS/Ecommerce/Shopping cart ?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Wed, 28 Jul 2010 22:24:07 -0700
"Joshua D. Drake" <jd@commandprompt.com> wrote:

> On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
>
> > BTW up to my memory Django suggest postgres. I haven't seen any
> > benchmark of Django with pg vs mysql.

> Django was originally developed for Postgres but really, they are
> wholly different beasts.

You're right. It would be nice to see benchmark of any cms developed
with Django on postgresql and mysql.
I tried to find benchmark of Plone on postgres vs mysql.

I'd tend to think (and I may be wrong) that as a rule of thumb,
being everything else equal, mysql is more suited to "commodity" cms
just because it is easier to find coupled with php in hosting (and
this reflects on communities etc...).

Still it would be nice to put the myth of mysql is better on cms,
since they are read most apps, to rest too.

But then... there are no popular [anything but php] cms but there
are a lot of [anything but php] web framework.

You start with a pre-packaged web application that looks like a
framework, then you start to do custom code, then you start to have
more impedance mismatch...
The more you've to code, the more you will prefer a framework and
postgres... but if you've coded enough it means you can afford to
code your own web application out of a framework and have your own
box (no hosting).

BTW which one of the example you posted uses ubercart?
I'd be curious about how many concurrent operation on the basket does
http://www.commandprompt.com/portal/
have...

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


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Comparison of Oracle and PostgreSQL full text search
Next
From: "Davor J."
Date:
Subject: Re: Inheritance and trigger/FK propagation