RE: PostgreSQL compatibility fixes

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

[quote="Cryp2Nite"][quote="pokryfka"]
there're are also functional indexes, generally pgsql is great
[/quote]
I don't know what you mean here, but there are a few queries that hit the database 10's of times per page, adding indexes for these queries help quite a bit.
[/quote]

i mean that if, for example, you often join tables using lower(name) you can index the values of lower(name), not just name so the function is not calculated every comparison
proper indexes seed up much
pgsql is just so much more powerfull... 

[quote="Cryp2Nite"]
[quote="pokryfka"]
i think osc needs abstrac db layer but it's up to the project leader when and how.
[/quote]
Sure, but a contribution won't hurt.

[quote="pokryfka"]
meanwhile it would be nice if they change some db related issues.
this would not break osc and would make the future shift easier.
[/quote]
I agree. But I understand shipping a 2.2 that works is the number one prority right now, so fixing mysql-isms probably isn't on the top of the todo list.
[/quote]

porting osc to a different db isnot a big deal
also i dont think maintaining a few different branches is 
a good thing to do

on the other hand it will take probably much time before osc incorporates some abstract db