Recently Amazon made Oracle database available an AWS service. What advantages Oracle databases have over MySQL? How about disadvantages (excluding the pricing, of course)?
Ask HN: Why would you choose Oracle over MySQL?
1–6 of 6 posts
Re: Ask HN: Why would you choose Oracle over MySQL?
#2You get to pay more for a DBA.
The mix is the message here, if you don't know what it does for you, you don't need it.
Re: Ask HN: Why would you choose Oracle over MySQL?
#3If you have a licence and people who know Oracle I'd definitely choose it. Look at and compare the feature lists - there is quite a difference even before you look at performance and scalability in a transactional system.
Re: Ask HN: Why would you choose Oracle over MySQL?
#4Simply, there are few reasons you might choose Oracle over MySQL or PostgreSQL.
- You have an application in your stack that requires it. - You are building an app that would be installed on cus tomer premises, and want to support enterprisey customers. - You have a founder, or early employee, or team that REALLY knows Oracle very well and doesn't know a cheaper database. - You're looking to be acquired by Oracle, or by an enterprise-type of company, like Cisco, EMC, etc.
Re: Ask HN: Why would you choose Oracle over MySQL?
#5Also if you're doing any government and "enterprise" gigs, hearing the word Oracle and Java somewhat makes them happy. I bet there's some Dilbert comic about it.
Re: Ask HN: Why would you choose Oracle over MySQL?
#6Google has a ton of decent into, search for "oracle vs mysql".
Both have their respected places, but Oracle is in general "more". More complicated, more difficult to install and configure, more flexible, more powerful, more money. If you don't need "more", then MySQL is quite capable.