Why would you use Oracle database?

BuddyJoe picture BuddyJoe · Feb 11, 2009 · Viewed 74.4k times · Source

I'm curious for technical reasons why you choose Oracle database versus the latest flavors of:
1) Microsoft SQL Server
2) MySQL
3) PostgreSQL

What features or functionality justify the extra cost. I'm interested in technical arguments, not a religious war. A friend asked me this and I've always used one of the 3 I listed. I didn't know enough about Oracle Databases to offer an opinion.

Thanks.

Answer

user1016765 picture user1016765 · Jan 4, 2013

Noone seems to talk about the cost of developers time working with Oracle. Most developers who know any other db hate Oracle, those that don't assume that all DB code and/or ORM tools are difficult to use.

If I started a business that I believed was going to scale to Amazon proportions I might consider NoSQL solutions, otherwise I'd choose PostgreSQL, SQL Server (or indeed even Sybase now) over Oracle every time. I say this having worked (as a dev) with Oracle for 2 years - its terrible to work with!