mysql怎么了?
我在互联网上的一些地方看到 MySQL 的未来是黯淡的。主要是人们说的不好。 MySQL真的“消亡”了吗?如果是这种情况......数据库解决方案有哪些好的替代方案?我在一家小公司工作,我们大量使用 MySQL。 postgre 是一个好的解决方案吗?如果我去一家更大的公司,学习如何使用什么东西会很有用?标准的企业数据库是什么(请不要说oracle)?
I've seen in a few places on the internet that the future for MySQL is bleak. Mainly people talking poorly about it. Is MySQL really "dying"? If this is the case.. what are good alternatives to database solutions? I work for a small company and we use a lot of MySQL. Is postgre a good solution? What's something that would be useful to learn how to use in the event I go to a larger company? What is the standard corporate database(please don't say oracle)?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
抱歉,Oracle、SQL Server、MySQL、Postgres 都是很好的数据库。您要问什么能让您有销路,而了解这个问题的最佳方法就是看看您所做的一切以及这与数据库有何关系。您是一名严格意义上的 DBA,然后在招聘网站上查找一下,看看有多少职位适合 MySQL DBA。 Oracle 和 SQL Server 可能会有更多。
您是使用 MySQL 的程序员吗?嗯,这是不同的,因为您应该更加不依赖于数据库。作为一名程序员,您应该能够跳转到任何数据库(甚至语言)并快速学习。
此外,Oracle 和 SQL Server 都有免费版本供您学习,因此您可以使用它们来学习。
至于“更大的公司”,我建议看看你认为是“更大的公司”,看看他们使用什么。在我工作的地方,我们使用 MySQL、Sql Server、Oracle 以及任何可以完成这项工作的东西(sqlite 等),但如果有一个标准的话,那就是 Oracle 和 SQL Server。
至于你的恐惧——任何事情都可能失败。看看世界历史就可以看到这一点。没有什么是确定的。广泛学习。
编辑:
这取决于工作描述。您必须进行研究才能了解市场需要什么。大公司喜欢大资金数据库(顺便说一句,因为它们是很好的数据库)。他们就是这么做的。是否有一些人喜欢 MySQL,当然,但在我看来,没有那么多。你必须搜索市场。这就是每个人在试图弄清楚外面需要什么时所做的事情。您可以用编程语言替换整个问题,并且您会得到相同的答案 - 研究。有很多网站专门介绍市场上的热门产品(顺便说一句,不要相信它们)。我确信 MySQL 不会有什么坏处,但如果工作需要 Oracle,而你甚至不知道如何列出 Oracle 中的表(这不是显示表),那么他们为什么要雇用你呢?但同样,取决于你在做什么,只是DBA,程序员,什么?如果您是一名程序员,您可能永远不需要列出这些表,因为 DBA 不会让您接触数据库。研究。
Sorry but Oracle, SQL Server, MySQL, Postgres are all good databases. You are asking what will make you marketable and the best way to look at that is to look at what ALL you do and how that has to do with databases. Are you strictly a DBA, then look that up on a jobs site and see how many jobs are for MySQL DBA. Oracle and SQL Server will probably have more.
Are you a programmer that uses MySQL? Well, that's different because you should be more database agnostic. As a programmer you should be able to jump to any database (even language) and learn quickly.
Also, Oracle and SQL Server have free versions you can learn with so you can use them to learn.
As to "larger company," I would suggest looking around at what you consider to be a "larger company" and see what they use. Where I work we use MySQL, Sql Server, Oracle, and anything that will do the job (sqlite, etc.), but if there was a standard it would be Oracle and SQL Server.
As to your fears - anything can go belly up. Look at the world's history to see that. Nothing is certain. Study broadly.
edit:
That depends on the job description. You HAVE to do research to see what the market is wanting. Big big companies like big big money databases (because they are good databases, incidentally). They just do. Are there some that like MySQL, sure but not as many, in my opinion. You must search the market. That is what everyone does when they are trying to figure out what is needed out there. You could replace your entire question with a programming language and you'd have the same answer - research. There are whole sites dedicated to what's hot in the market (don't believe them all btw). I'm sure MySQL wouldn't hurt but if the job calls for Oracle and you don't know how to even list the tables in Oracle (which is not show tables), then why would they hire you? But again, depends on what you are doing, just DBA, programmer, what? You may never have to list the tables if you are a programmer because the DBAs won't let you touch the database. Research.
对于 MySQL 的未来,我宁愿让其中一位创建者来说话:http: //askmonty.org/w/images/a/a4/Osd2010.pdf
更不用说 Oracle 刚刚将 InnoDB(一种非常流行的 MySQL 存储引擎)商业化了。 http:// www.cloudave.com/7356/internal-email-on-why-a-software-company-migrates-away-from-mysql/
不用说,它不会去任何地方,但它肯定不是免费使用的(实际上从来没有免费过,但现在 Oracle 将在他们想要的任何时候确保 GPL)。
继 MySQL 之后,PostgreSQL 是最常用的开源免费(如啤酒)数据库。
在商业(高成本)方面。 Oracle 仍然是最常用的数据库。但如果您的软件不需要 DBA 作为客户每月的维护成本,那么这无疑是一种矫枉过正。
For the future of MySQL I would rather let one of the creators do the talking : http://askmonty.org/w/images/a/a4/Osd2010.pdf
Not to mention that oracle just made InnoDB (a very popular MySQL storage engine) commercial only. http://www.cloudave.com/7356/internal-email-on-why-a-software-company-migrates-away-from-mysql/
Needless to say it is not going anywhere but it is not free to use for sure (never was actually but now oracle will ensure GPL anytime they want).
After MySQL, PostgreSQL is the most used open source free (as in beer) database.
On the commercial (high cost) side. Oracle is still the most used database. But it is most certainly an overkill if your software does not need a DBA as a monthly maintenance cost to the customer.
MySQL 已经非常完善,并且没有任何发展的迹象。人们总是预测这个或那个会消亡,但这只是一堆噪音。尽管如此,我还是会学习多个数据库,因为你将成为一名更全面的开发人员。了解 Oracle 在就业市场上非常有价值。
MySQL is very well established and shows no signs of going anywhere. People are always predicting this or that will die off, but it's all just a bunch of noise. Still, I would learn multiple databases as you will be a more well rounded developer. Knowing Oracle is very valuable on the job market.