Vivek Khera wrote:
On Feb 16, 2007, at 4:13 PM, Andrew Kirkness wrote:
I am currently setting up a website and have PostGreSQL database I'm
using for the backend. I'm researching an open source Content
Management System that uses PostGreSQL. Do you have any recommendations?
You need to define what you want your CMS to do, before you get good
recommendations.
We've investigated a bunch of systems for publishing a magazine-type
site, http://www.morebusiness.com/ and have discovered that pretty
much all of them like to work with mysql :-(
I think this is because many of the designers of the free, lower-end,
software don't truly appreciate the relational SQL model and treat the
DB as a dumb store. Once you move higher-up in the chain, you start
to see better data models, and they lean toward using Pg instead...
I can't figure out what you want to do with customer data and the
CMS. Without knowing that, nobody can really say anything meaningful
to you. Are your customers providing the content?
Despite this lack of clarity, I can recommend that you first define
the features you want and then evaluate the systems based on those
features being available. Then all else being equal, use the
preferred DB as your tie breaker. I wouldn't rule out some good
software just because it uses mysql on the back-end.
------------------------------------------------------------------------
Bricolage uses PostgreSQL as its backend.
http://www.bricolage.cc
