open source - content management system - that uses PostGreSQL

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?

Drupal is excellent and supports PostgreSQL: http://drupal.org

Here is a link about installing Drupal with PostgreSQL:

http://pgedit.com/install_drupal

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

John DeSoi 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?

Drupal is excellent and supports PostgreSQL: http://drupal.org

Here is a link about installing Drupal with PostgreSQL:

http://pgedit.com/install_drupal

However,

If you are going to use Drupal on a site with a lot of content make sure
you rip out the search and plug in tsearch2.

Joshua D. Drake

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Sun, 2007-02-18 at 09:59 -0500, John DeSoi 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?

Drupal is excellent and supports PostgreSQL: http://drupal.org

Here is a link about installing Drupal with PostgreSQL:

http://pgedit.com/install_drupal

I'd also highly recommend eZpublish from eZsystems.
http://ez.no

Andy

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.

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

One nice CMS package -- it doesn't force you to use Postgresql, but that is
(IIRC) the default -- and python:
http://www.djangoproject.com/

HTH--

-frank