[Phpwebsite-developers] Postgres Support (making progress...)

[Brian G. <br...@vf...>]

Greetings, I've just joined the list and have scanned the archives for 
PG-related info in the past.  I've spent about 6-8 hours trying to convert 
phpwebsite 0.9.3 to support postgres.  So far, so good, although I've run 
into some issues around the sequence support.  For the most part, I've 
modified everything enough to install all of the modules but the database 
routines don't quite work yet. 

I've done a number of things including: 

* Rewrite sqlGetIndex() to work for postgres (although this will be 
database-specific and might be worth dropping such a routine) 

* Update all of the module install.sql and setup/install.sql to be more 
ANSI-compliant and use SQL-standard syntax for creating indexes 

Two pieces of documentation would be extremely helpful in moving forward: 

1. An ER diagram of the database model for PWS that states, in a 
database-independent fashion, what the relationships and datatypes should 
be.  For example, it's hard to know which fields should be unique primary 
keys and which should just be indexed from the SQL scripts. 

2. Dev roadmap that gives some rough direction of which files, systems or 
libraries need to be worked on to achieve database-independence.  That way 
contributors can do some heavy lifting. 

I know that 0.9.4 which is supposed to be db-independent is on something of 
a ~Spring release schedule but I need good postgres support before then.  
I'm hoping to take advantage of my enthusiasm if I can get a little 
direction and perhaps I can piggyback on Richard S' work to date. 

One big question I have is how are the auto-incrementing fields used?  Are 
they necessary?  I saw some discussion in the archives from August but no 
clear decisions? 

Is there a semi-stable tagged CVS build that is more recent than what's on 
the website I can work from? 

Thanks, 


Brian