[phpesp-dev] Port to ODBC

[Stefan C. <sch...@ea...>]

Continuing my work to port phpESP to ODBC/Oracle, I stumbled against a few 
problem because phpESP was primarily developped for mySQL. When moving to 
Oracle beware that there's no auto_increment and thus we must use sequence. 
To be able to predevelop outside the heavily controlled Oracle environment, I 
figured out that it'd be better if I used PostGreSQL, because it provides 
sequences and, more importantly, good support for subqueries (an area where 
MySQL traps you way too much in its own DB paradigm (IMHO)). Therefore, 
I'mprobably going to try to port everything to PostgreSQL and when I'm done, 
I'll move everything to Oracle. Again, it may sound a little overkill, but 
the DBA are so reluctant/busy to leave me alone in a ORA sand-box that I have 
to go my own way.

stF