postgres或oracle数据库中的mangento？
我需要一个开源电子商务解决方案，我认为 magento 是一个出色的电子商务解决方案，但我不能使用 mysql，因为这是客户要求，而 magento 只提供 mysql 数据库支持。
在 postgres 或 oracle 中设置 magento 有什么技巧吗？
提前致谢 ！！！
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 !!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我认为它作为解决方案并不可靠，原因如下：
a）通常magento开发团队几乎在每个版本中都会升级他们的mysql数据库表（没有适当的文档），因此您将被迫在每次发布后手动升级您的数据库结构更改（忽略magento升级是不明智的，因为它们每次都会修复相当大的错误列表（并一路引入一些新错误：P））。
b) Magento 的数据库结构非常复杂，将所有内容移植到另一种类型的 DBMS 中，并使用它自己的外部键推理等，将是一项地狱般的工作
c) 最后：我不确定他们的数据库引擎会支持一种新的 DBMS（应该是 Zend_Db，但谁知道呢）。
我建议你说服客户使用mysql（因为无论如何你都需要专用服务器才能顺利运行magento）
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)
Alekc 是绝对正确的，移植到另一个数据库是不可行的。我不确定您的客户不想要 MySQL 的原因是什么，但也许如果花钱让他们放心，他们可以购买 MySQL Enterprise 许可证，其中包括全面支持： MySQL 企业版
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
如果您必须使用 Postgresql，请看一下 Bitcommerce。据我所知，它是唯一一个功能齐全且完全支持 Postgres 的电子商务解决方案。
https://github.com/bitweaver/bitcommerce
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.
https://github.com/bitweaver/bitcommerce
您可以在这里了解 magento 的“企业”功能 - 与 php 世界中的惯例一样，这个词被用作纯粹的营销术语，没有任何支持。
如果您仔细观察，您会发现 magento 中发生了许多非常奇怪的事情，这对于 php 开发人员来说是典型的，他们不想看看他们的贫民区之外正在发生什么。
我建议使用现代 python web 框架并在 postgresql 上构建系统，而不是依赖 magento 代码（如果您不是绝对需要这样做）。这将为您省去很多痛苦和金钱。最后，您会非常高兴不必依赖 PHP 开发人员，他们似乎不了解“企业”真正让人们期待什么。
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.
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.
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.