Thread: 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 ==========================================================================