Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

convert mysql to postgres - anyone succeeded running osc?


noteability

Recommended Posts

It should not be too hard. You will have to modify all of the functions in catalog/includes/functions/database.php and admin/includes/functions/database.php to use PostGres calls instead of MySQL calls.

 

Of course, you will need to modify the database definitions to be PostGres as well but that should not be too difficult either.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Not that I know of.

 

The article that you linked to is a bunch of bunk. I have a lot of websites all running MySQL without failure or error.

 

Just do a search for osCsid at Google and look at the number of returns you get. Then figure that if each of them were having problems they would be here complaining (if this forum could handle that kind of traffic).

 

Lastly, the company that I resell for is very conscientious about security and stability with average server uptimes of 68 days. Postgres is not used but MySQL is.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Thats more reassuring. I have a postgres app I want to be able to link to osc db to have one inventory being updated. Its acually a Point of Sale system and I have plans to have the web site hosted by the owner of the site (he wants that and I'm not an ISP). He has a shopfront and wants a POS system (found a GNU one but runs on postgres, can't find one that runs on mysql). I will then modify the shopfront app to use the OSC db instead of its postgres, modify its calls to use the OSC schema etc and he can host the DB at the shop while the web shop will update the DB on his machine at the shop too as the web server does not have to be the same machine as the DB server (am I correct here? - thats how I thought it could work). Not a small task but when I get it to work I will then be able to offer the POS as a contrib. If anyone can find a POS (GNU) that runs on mysql, I'm sure I can tweak it to use the OSC DB instead of its own. The other alternative is to run the POS independent and after hours, update the OSC DB. But its not elegant or timely enough, so I'll put the hours in.

 

Joe - in Sydney Australia

Link to comment
Share on other sites

Have you looked at PHP Point-of-Sale?

 

I do not know anything about but just found it doing a search on "point of sale" +mysql at Google. You would probably get better results replacing mysql with php since most things php use mysql.

 

I hope that some of this is of some help.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...