RE: PostgreSQL compatibility fixes

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

[quote="cannuck1964"][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]
I don't have a link, I just think I remember seeing some mention of it in another thread.

[quote="cannuck1964"]
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]
Any abstraction layer is going to produce some overhead. But so does not doing abstraction, it just disguises itself as increased development time. The trick is to find the right balance. 
That being said, the perfomance penalty for using PEAR seems to be significant, so other options should be considered. But ripping out PEAR DB and using some other method is simply a matter of replacing functions/database.php and pretty straight forward.


[quote="cannuck1964"]
Well this type of query is not found in osc anywhere,  <snip> I do not think we need to concern ourselves with it at present.....
[/quote]
You're right, but I was just taking a guess at what pokryfka could have meant.

[quote="cannuck1964"]
<snip>......Once I am done with the mall I am going to concentrate on this DB layer idea....
[/quote]
If you do get started on this, feel free to contact me to see if there's any way to join forces. 
Most of the time involved in this is probably in testing and benchmarking different aproaches.

Cheers,
Rob