noteability Posted May 27, 2003 Posted May 27, 2003 Has anyone successfully converted mysql to postgres and is runnning osc against this postgres db?
Daemonj Posted May 27, 2003 Posted May 27, 2003 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
noteability Posted May 27, 2003 Author Posted May 27, 2003 the following hsows me how to do it - just may need to find out how to change the calls http://www.sitepoint.com/article/529 But has anyone got it working? Joe
Daemonj Posted May 27, 2003 Posted May 27, 2003 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
noteability Posted May 28, 2003 Author Posted May 28, 2003 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
Daemonj Posted May 28, 2003 Posted May 28, 2003 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
noteability Posted May 28, 2003 Author Posted May 28, 2003 What a great start - thanks for the help - was looking for POS and php!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.