RE: PostgreSQL compatibility fixes

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=218788#218788
----------------------------------------------------------------

[quote]the vast majority of the changes i made are small sql querries fixes. 

the new queries are more ANSI SQL compilant and works both on PostgreSQL and MySQL. [/quote]

Good idea, actually what I would like to see placed into one of the up-coming MileStones, is for the entire project to use ANSI T-SQL rules.  As well as an abstract Database Layer which would allow for pretty much any DB to be used with OScommerce.

With the use of an abstract DB, This project could be used on pretty much any system configurations.  Post Nuke has a good DB Layer, which while I do not promot the team to use explicitly, might be a good base to make the whole system much more systems platform indepentant.

Would be a great thing to have, and if the team is not interested, I will be doing so as my next major project for OSC.


cheers