Jeff Moden (11/14/2016)
kevaburg (11/14/2016)
Jeff Moden (11/14/2016)
Title of this post:
Difference between MySQL and Oracle? What's better?Answer: SQL Server. 😉
and thus start the flame wars.... 😀
No... no flame wars. Considering that the OP has apparently done zero research on the differences of two very different database engines, I thought I'd throw in a third. We can also throw in NoSQL and a ton of other "engines" because no one engine has everything that might ever occur when it comes to "which is better". The OP even appears oblivious that MySQL has two different engines and, unless you need support, is basically free compared to the rather expensive Oracle.
I really am concerned for those companies and people where people post such questions. It means they've done zero homework and there's no way that a single thread like this one could actually answer such a question. You're talking about something the company or an individual career is going to need to live with for a long time so trivial answers on a thread such as this should not be a driving factor in what a company or individual chooses but frequently is, and it's frightening.
Either that or Yabingooglehoo is broke again. 😀
I know what you mean with you second paragraph. I actually like Oracle alot. It is hideously complex for the same Action in SQL Server most of the time, basic functions like partitioning, spatial and Real Application Testing cost an enormous amount and are only available as add-ons (even though Oracle ships the functions with the Software...) but I learned the most about databases thanks to the need to know and understand the architecture inside out.
With SQL Server I have found that anyone that can use a mouse and can log on to the database immediately thinks they are an admin (read that for almost every Microsoft product) and they produce the most awful results. There are very few that REALLY put the effort in to learning the concept of a database. This is what I think is most dangerous but then said individuals and companies need to realise that themselves.