RE: PostgreSQL compatibility fixes

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

Hi

[quote]AFAIK it is/was targeted after the 2.2 release. [/quote]

Not sure, where did you find this info?  This is a grand idea, and I believe it will only help to make osc much better....If the team has plans in this direction, some input from them in this thread would be greatly appreciated by myself.....


[quote]Experminting with different solutions would be a good idea, the PEAR solution is causing a bit of overhead and I have been thinking about replacing it with straight pg_* php funtions. [/quote]

Well I am not advocating to use the PN DB layer, just a DB layer, I like how PN works, and well it has a very good code base ....Any method that works and does not produce additional over-head would be the way to go....either from scratch or by modifing existing code.....


[quote]I'm not sure but didn't MySQL just recently get the ability to do subselects? E.g. 
SELECT * FROM addresses WHERE contact_id = (SELECT id FROM contacts WHERE nick = 'cannuck1964'); [/quote]

Well this type of query is not found in osc anywhere, nor do I believe will it be used, since osc has compatability between different versions (PHP and MySQL) as a prime objective.  Since this looks to be a new feature, and would not be backwards compatable, I do not think we need to concern ourselves with it at present.....

I am in the middle of building a virtual mall with osc, and I believe that this abstact DB layer idea would finish off the project to where I want it to go......Once I am done with the mall I am going to concentrate on this DB layer idea....


cheers