postgres 或 oracle 数据库中的 mangento？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1520673/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
mangento in postgres or oracle database?
提问by Eudris Cabrera
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.
我需要一个开源电子商务解决方案，我认为 magento 是一个出色的电子商务解决方案，但我不能使用 mysql，因为这是客户要求，而 magento 仅提供 mysql 数据库支持。
any tips to setup magento in postgres or oracle ?.
在 postgres 或 oracle 中设置 magento 的任何提示？
thanks in advance !!!
提前致谢 ！！！
采纳答案by Alekc
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)).
a) 通常 magento 开发团队几乎在每个版本中升级他们的 mysql db 表（没有适当的文档），所以你将被迫在每次更改后手动升级你的数据库结构（忽略 magento 升级是不明智的，因为它们修复了相当大的列表每次都会出现错误（并在很长一段时间内引入一些新的错误：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
b) Magento 的 db 结构非常复杂，将所有内容移植到另一种类型的 DBMS 中将是一项地狱般的工作，因为它有自己的外部键等原因
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).
c) 最后一点：我不确定他们的数据库引擎是否会支持一种新的 DBMS（应该是 Zend_Db，但谁知道呢）。
I'd suggest you to convince client in using mysql (since you would need dedicated server anyway for running smoothly magento)
我建议您说服客户端使用 mysql（因为无论如何您都需要专用服务器才能顺利运行 magento）
回答by ColinM
Alekc is absolutely right, porting to another db is infeasible. I'm not sure what reasons your client has for not wanting MySQL, but perhaps if spending money puts them at ease they could purchase the MySQL Enterprise license which includes full support: MySQL Enterprise
Alekc 是绝对正确的，移植到另一个数据库是不可行的。我不确定您的客户不想要 MySQL 的原因是什么，但也许如果花钱让他们放心，他们可以购买包含全面支持的 MySQL Enterprise 许可证：MySQL Enterprise
回答by Stickley
If you must have Postgresql, give Bitcommerce a look. As far as I know, it is the only feature complete eCommerce solution with total Postgres support.
如果您必须拥有 Postgresql，请查看 Bitcommerce。据我所知，它是唯一一个完全支持 Postgres 的功能完备的电子商务解决方案。
回答by Magento Expert
You can learn here about the "enterprise" features of magento - as usual in the php world, this word is used as a pure marketing term, not backed by anything.
您可以在此处了解 magento 的“企业”功能 - 像在 php 世界中一样，这个词被用作纯粹的营销术语，没有任何支持。
If you take a closer look, you will see many very strange things happening in magento, which are typical for php developers which do not want to take a look what is happening outside of their ghetto.
如果您仔细观察，您会发现 magento 中发生了许多非常奇怪的事情，这对于 php 开发人员来说是典型的，他们不想查看他们的 ghetto 之外发生的事情。
I reccomend using a modern python webframework and build your system on postgresql and not rely on magento code, if you do not absolutely need to do it. This will save you a lot of pain and money. You will, in the end, be very happy not having to rely on php developers that do not seem to understand what "enterprise" really makes people expect.
我建议使用现代 python 网络框架并在 postgresql 上构建你的系统，而不是依赖于 magento 代码，如果你不是绝对需要这样做的话。这将为您节省很多痛苦和金钱。最后，您会很高兴不必依赖那些似乎不了解“企业”真正让人们期待什么的 php 开发人员。
