Menu
i need an open source ecommerce solution, i think magento is an excellent ecommerce solution but i can't use mysql because is a customer requirement and magento only offer mysql database support.
any tips to setup magento in postgres or oracle ?.
thanks in advance !!!
220
PostgreSQL is by no means a drop-in replacement for Oracle's database, but a developer or DBA that is familiar with Oracle will find PostgreSQL similar.
Why use PostgreSQL? PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset.
Oracle database management systems, the main difference between these two databases is that PostgreSQL is an open-source database, while Oracle is a closed database system. PostgreSQL is a free relational object-oriented database management system that is developed by volunteer developers worldwide.
One of the biggest advantages of choosing the EnterpriseDB version of PostgreSQL is its Oracle compatibility.
I don't think that it would be reliable as the solution for several reasons:
a) Usually magento dev team upgrade their mysql db tables almost in every release (without proper documentation) so you will be forced to upgrade manually your db structure after every change (it's not wise to ignore magento upgrades, since they fix pretty big list of bugs everytime (and introduce some new bugs long the way :P)).
b) Magento's db structure is very complex, and it would be an hellish job to port everything in another type of DBMS with it's own reasonings for external keys and such
c) And in the last: I'm not sure that their db engine would support a new kind of DBMS (it should be Zend_Db but who knows).
I'd suggest you to convince client in using mysql (since you would need dedicated server anyway for running smoothly magento)
193
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
