Обсуждение: Drupal and postgreSQL

All.....

After reading about the Drupal CMS using mysql *OR* postgreSQL I've been
experimenting with it, setting it up with postgreSQL and playing.
Another fellow and I are considering using it more, but when we loaded the
ecommerce module we could only find a table definition file for
mysql......

A search revealed a user working on that front, but he wasn't completely
successful.

I'm probably going to connect Drupal to mysql and play some more.  If we
end up using it I'm leaning toward converting the ecommerce module table
definition file from mysql to postgreSQL, I'll cross that bridge when we
come to it.

In the meantime...... can anybody around here shed any light on using the
Drupal ecommerce module with postgreSQL?

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================

On Jan 14, 2006, at 2:46 PM, brew@theMode.com wrote:

> I'm probably going to connect Drupal to mysql and play some more.
> If we
> end up using it I'm leaning toward converting the ecommerce module
> table
> definition file from mysql to postgreSQL, I'll cross that bridge
> when we
> come to it.
>
> In the meantime...... can anybody around here shed any light on
> using the
> Drupal ecommerce module with postgreSQL?

I have used parts of the module (primarily the address management)
and I did not find it difficult to port for PostgreSQL. It appears
redoing the table definitions for PostgreSQL is the primary task.
This should not be too difficult, and there are some automated tools
which might be helpful:

http://sqlfairy.sourceforge.net/
http://software.newsforge.com/software/05/12/15/1611251.shtml



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

On Sat, 14 Jan 2006, John DeSoi wrote:

> > In the meantime...... can anybody around here shed any light on using
> > the Drupal ecommerce module with postgreSQL?
>
> I have used parts of the module (primarily the address management)  and
> I did not find it difficult to port for PostgreSQL. It appears redoing
> the table definitions for PostgreSQL is the primary task.  This should
> not be too difficult, and there are some automated tools which might be
> helpful:
>
> http://sqlfairy.sourceforge.net/
> http://software.newsforge.com/software/05/12/15/1611251.shtml

That does seem to be the case, but since we are just playing with it to
evaluate whether we actually want to use it, I switched to running it with
mysql.  I'm afraid of the time I might put in making changes.

Drupal does seem well thought out.  There is a database function
definition page which is called in depending on whether you are running
mysql or postgreSQL.

The basic drupal (version 4.6.5) was running on PostgreSQL satisfactorily,
it's only some of the extra modules that don't have a table definition
file for postgreSQL, they only have the table definitions for mysql.

If we end up using drupal I'll run it on postgreSQL and also establish
communication with Adrian Rossouw, the Maintainer for the Postgres Port of
drupal.

Thanks, John

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================