MySQL与SQL Server Express [英] MySQL versus SQL Server Express

问题描述

Sun最近购买MySQL以及随后的错误发布会杀死MySQL品牌吗?

Did the recent purchase of MySQL by Sun and the subsequent buggy releases kill the MySQL brand?

MySQL刚问世时，我就全心全意地拥抱MySQL，因为我以前是一个贫穷的开发人员，而且所有RDBM都太昂贵了.我对MySQL以及它们能够与Oracle和SQL Server竞争感到很满意.我将最初的MySQL团队归功于SQL Server Express的存在.现在，我几乎使用SQL Server Express代替MySQL.首先，我不喜欢Sun，其次，SQL Server Express比MySQL更加健壮和企业化".

I whole heartedly embraced MySQL when it first came out as I used to be a poor developer and all the RDBMs were too expensive. I have fond feelings for MySQL and their being able to compete with Oracle and SQL Server. I credit the original MySQL team for the existence SQL Server Express. I now use SQL Server Express instead of MySQL for just about everything. First, I do not like Sun and second, SQL Server Express is significantly more robust and 'Enterprise' than MySQL.

SQL Server Express的唯一重要限制是4GB db大小和缺少代理.我发现大小限制不是问题，因为到数据库接近该大小时，应用程序应该可以盈利(您购买许可证)，或者应该终止该产品.代理问题很高兴，但并非至关紧要，因为您可以解决它.

The only significant limitations on SQL Server Express are the 4GB db size and the lack of Agent. I find that the size limit is not a concern because by the time the db gets close to that size, the application should either be profitable (and you buy the license), or you should kill the product. The Agent issue is a nice to have, but not critical as you can work around it.

对于像我这样的数据库简单人士来说，SQL Server Express似乎更易于设置和使用，并且更快，更稳定.对于专家，他们将使用PostgresSQL ...

It seems that for db simpletons like me, SQL Server Express is easier to setup and use and is faster and more stable. And for gurus, they will use PostgresSQL...

已解决:

因此，基本上，我们在stackoverflow上有一堆SQL Server风扇(尽管思想开放).看来我来对地方了.这是可悲的看到从MySQL的东西你欢呼的东西你怜悯变换.我希望原始公司的创始人尝试新的尝试.我绝对不判断他们是否要卖给SUNW-工作自然是利润驱动的.希望我们得到一些拥有FU钱的人，他们不关心利润，而创造了像MySQL这样的某些产品.否则，MSFT可能会取代EXPRESS.

So basically, we have a bunch of SQL Server fans (albeit open-minded) on stackoverflow. It looks like I'm in the right place. It's sad to see MySQL transform from something you cheer to something you pity. I hope the founders of the original company try a new endeavor. I absolutely do not judge them for selling to SUNW - work is naturally profit driven. I hope we get some people with FU money who don't care about profits who create some products like MySQL used to be. Othewise, MSFT might take away EXPRESS.

推荐答案

两者都可以使用，我不得不说MySQL的局限性和/或错误对我来说是个很大的选择...我不喜欢PHP，虽然我尊重开源社区在这两种技术方面的进步，但我无法以两者的组合方式来展现优雅.但是，不要让我的个人品味影响您对MySQL的判断.

Having worked with both, I have to say that the limitations and/or bugs in MySQL were a big turn off for me... I don't like PHP, and while I respect the open source community for their advances with these two technologies I just can't see the elegance in the way either of them have been put together. But don't let my personal taste sway your judgement against MySQL.

我在SQL Server Express中进行所有原型制作，并且大多数客户端使用功能全面的SQL Server2005.从一个版本过渡到另一个版本的便利性使我无所顾忌-我可以接受为SQL编写的任何内容Server Express并直接使用它，而不必担心语法可能有所不同.这两个限制甚至在开发环境中并没有真正成为障碍-只是在您进入生产阶段时，它们才会成为问题.

I do all of my prototyping in SQL Server Express and most of my clients use full blown SQL Server 2005. The ease of transition from one to the other makes it a no brainer for me - I can take anything I wrote for SQL Server Express and put it straight in without worrying that the syntax might be different. The two limitations don't even really get in the way in a dev environment - it's only when you come to production that they would tend to be a problem.

对我来说，SQL Server赢得了争论.

For me, SQL Server wins the argument hands down.

这篇关于MySQL与SQL Server Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！