I've finished install function with postgresql, see the attachment. It is not difficult as imagination. Is there anybody join us? Tester are more popular.
Attached Files
-
oscommerce-pgsql.sql.txt 171.25K
7 downloads
Latest News: (loading..)
0
I want to migrate oscommerce 2.3.1 from mysql to postgresql. Who will join us?
Started by shooray, Oct 13 2011 05:00 PM
postgresql
10 replies to this topic
#1
Posted 13 October 2011 - 05:00 PM
I need oscommerce to support postgresql. To my disappointed, the osc official team has not any desire to work with it. I have to do it myself.
I've finished install function with postgresql, see the attachment. It is not difficult as imagination. Is there anybody join us? Tester are more popular.
I've finished install function with postgresql, see the attachment. It is not difficult as imagination. Is there anybody join us? Tester are more popular.
#4
Posted 15 October 2011 - 09:26 AM
Foayiid, on 13 October 2011 - 05:07 PM, said:
Hi Shooray,
If you have followed the github you would know that the postgreSQL support have been done the september 21 and 23 by Harald.
It is the danger to work on a alpha ...
Fred
If you have followed the github you would know that the postgreSQL support have been done the september 21 and 23 by Harald.
It is the danger to work on a alpha ...
Fred
Hi Fred, what does you mean? I don't really like to do it myself, but nothing about postgresql is found. Would you please tell me where is the oscommerce postgresql migiration project? version 2.3.1 or 3.0.x?
#5
Posted 15 October 2011 - 04:54 PM
The next release of v3 will be able to turn on Postgre.
you can follow this on the Harald Github : https://github.com/haraldpdl
you can follow this on the Harald Github : https://github.com/haraldpdl
#7
Posted 16 October 2011 - 09:47 AM
Quote
What can I do for osc3 and postgresql?
He's actually working on the "product" manager.
And the "order" manager is missing too.
Quote
will be able to... when? I need it right now. How hard to complete it in the end?
#8
Posted 17 October 2011 - 10:00 PM
Foayiid, on 13 October 2011 - 05:07 PM, said:
Hi Shooray,
If you have followed the github you would know that the postgreSQL support have been done the september 21 and 23 by Harald.
It is the danger to work on a alpha ...
Fred
If you have followed the github you would know that the postgreSQL support have been done the september 21 and 23 by Harald.
It is the danger to work on a alpha ...
Fred
Assuming that the SQL is identical between the two (IDK for sure), you could install a compatibility layer to map MySQL function calls to Postgresql calls. This assumes that it's not hard to map the function arguments from one to another. To do it right would require that all the database calls be changed to some generic form, and a library installed to map these generic calls to MySQL, PostgreSQL, etc. It could be done, but I can see why the developers wouldn't want to bother with osC 2.x. I have no experience with PostgreSQL, so I can't tell you the specifics.
#9
Posted 22 October 2011 - 05:48 AM
Hi, MrPhil:
I have compared osc 2.x with osc 3.x. Obviously, osc 3.x is more structured than osc 3.x.However, osc 3.x used too many new php features to be understood. I am not good at php, so a simple application is what I like.
Since SUN corp. was sold to Oracle corp., I decided to use PostgreSQL instead of MySQL. Actually, PostgreSQL is more steady and powerful than MySQL.
I don't intend to make a php compatibility layer with different database, and I have no so ability to achieve it as mentioned above. I just want to migrate oscommerce 2.3.1 to PostgreSQL. oscommerce 2.3.1 hasn't used any MVC framework, so there are much more sql code together with html and business logic, and many MySQL private functions and nonstandard SQL syntax are used. It is so difficult to make a database layer in osc 2.x. Maybe it is the reason that Haraldpdl is working at osc 3.x. On the other side, it's the reason that I decide to use osc 2.x, haha.
I have almost finished migration work with osc 2.3.1. I will push the source code to github. My address is: https://github.com/shooray. Please stand by because I am not experienced with github.
BTW: Is there anybody join us? Tester are more popular. please mail to shooray@gmail.com
I have compared osc 2.x with osc 3.x. Obviously, osc 3.x is more structured than osc 3.x.However, osc 3.x used too many new php features to be understood. I am not good at php, so a simple application is what I like.
Since SUN corp. was sold to Oracle corp., I decided to use PostgreSQL instead of MySQL. Actually, PostgreSQL is more steady and powerful than MySQL.
I don't intend to make a php compatibility layer with different database, and I have no so ability to achieve it as mentioned above. I just want to migrate oscommerce 2.3.1 to PostgreSQL. oscommerce 2.3.1 hasn't used any MVC framework, so there are much more sql code together with html and business logic, and many MySQL private functions and nonstandard SQL syntax are used. It is so difficult to make a database layer in osc 2.x. Maybe it is the reason that Haraldpdl is working at osc 3.x. On the other side, it's the reason that I decide to use osc 2.x, haha.
I have almost finished migration work with osc 2.3.1. I will push the source code to github. My address is: https://github.com/shooray. Please stand by because I am not experienced with github.
BTW: Is there anybody join us? Tester are more popular. please mail to shooray@gmail.com
#10
Posted 22 October 2011 - 03:32 PM
OK. The oscommerce2-mypgsql project is https://github.com/shooray/oscommerce2-mypgsql.
Beta1 is ok. Somebody can download it for test. Here it is. https://github.com/downloads/shooray/oscommerce2-mypgsql/oscommerce2-mypgsql.beta1.zip
Beta1 is ok. Somebody can download it for test. Here it is. https://github.com/downloads/shooray/oscommerce2-mypgsql/oscommerce2-mypgsql.beta1.zip
#11
Posted 23 October 2011 - 12:39 AM
I know that Evil Empire jr. Sun now controls MySQL, and if you want to take a no-MySQL stand on principles (or just as insurance against having to pay for it in the future), that's your call. Actually, haven't several Free clones of MySQL appeared since the Sun takeover? That might be the best of both worlds -- MySQL compatibility and Free.
As a general rule, an application should never be tightly tied to any one database, in order to give users the option to change databases for any reason.
As a general rule, an application should never be tightly tied to any one database, in order to give users the option to change databases for any reason.
