Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PostgreSQL Database Compatible?


mr.miKe

Recommended Posts

Hello, I'm new to OScommerce and so far think it's incredible with unlimited potiental! My question is OScommerce compatible with PostgreSQL database? If not, will it be in the futute? If so, how do you make it compatible? Is there any documentation?

 

Many thanks & keep up the great work!

 

mr. miKe :wink:

Link to comment
Share on other sites

It is not compatible with Postgre SQL at this time. You can change the queries and make it compatible if you wish since it is open source, however the likelihood that that will become a standard feature in the near future is really low because of how the database integration is in the code.

Link to comment
Share on other sites

  • 2 months later...

Just wanted to throw in some more support for making OsCommerce database independant. We use PostgreSQL on all our production servers, so I have to run a completely seperate MySQL install just for OsCommerce.

 

It would probably be advantageous to convert from MySQL to standard SQL as this would let not only PostgreSQL but a lot of other databases be used as backends. If you're not interested in standardizing the SQL code yourselves, would you accept patches? I'm Perl programmer myself but Perl has a database API called DBI that lets you write SQL code that works with any SQL database - I bet PHP has something similar.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...