Mangento in a postgres or oracle database?

Question

I need an open source ecommerce solution, I think magento is a great ecommerce solution, but I cannot use mysql because it is a client requirement and magento only offers mysql database support.

any tips for setting magento in postgres or oracle ?.

thanks in advance!

Answer 1

I do not think this would be a reliable solution for several reasons:

a) Typically, the magento dev command updates its mysql db tables in almost every release (without the appropriate documentation), so after each change you will be forced to manually update your db structure (it is not wise to ignore the magento update because they fix a rather large list of errors every time ( and introduce some new errors for a long time: P)).

b) The structure of Magento db is very complex, and it would be a hellish task to transfer everything to another type of DBMS with its own arguments for foreign keys and such

c) And in the last: I'm not sure that their db engine will support a new kind of DBMS (it should be Zend_Db, but who knows).

I would advise you to convince the client to use mysql (since in any case you need a dedicated server for smooth magenta)

Answer 2

Alekc is absolutely right, porting to another db is not allowed. I'm not sure why your client does not need MySQL, but maybe if you spend the money, they can purchase a MySQL Enterprise license, which includes full support: MySQL Enterprise

Answer 3

Here you can learn about the "corporate" features of magento - as usual in the php world, this word is used as a pure marketing term, not backed up by anything.

If you take a closer look, you will see many very strange things happening in magento that are typical for php developers who don't want to watch what happens outside their ghettos.

I recommend using a modern python web framework and building your system on postgresql and not relying on magento code if you don't need it. This will save you a lot of pain and money. In the end, you will be very pleased that you should not rely on php developers who do not seem to understand what the “enterprise” really makes people wait.

Answer 4

If you must have Postgresql, take a look at Bitcommerce. As far as I know, this is the only feature of a complete e-commerce solution with general Postgres support.

https://github.com/bitweaver/bitcommerce