"Best" is super subjective and difficult or impossible to measure. It's in the eye of the beholder.<p>Oracle DB is the "do everything database", it has nearly every DB paradigm "all-in-one", and is an extremely well-tested and predictable product. It often comes bundled with entire vertical solutions like "Bank in a Box" or "CRM", and with a contract including SLAs, so you're covered if/when things go wrong (as long as you pay $$$).<p>There are a lot of pros and cons, too many to enumerate on a Thursday night before dinner.<p>Bottom line: Oracle DB can be super expensive, but if you pay [enough] then Oracle will give you endless support to ensure you are successful (so you can keep paying them). They have some top-notch in-house expertise and there are good reasons large businesses keep paying the bill and renewing contracts (some part lock-in, other part solving real business needs).<p>Personally, I really like Postgres and SQLite. But they're no Bank-in-Box, and the support is comprised of "<a href="https://google.com/?q=" rel="nofollow">https://google.com/?q=</a>...".
I don't think anyone other than a very very small number on HN would consider Oracle the "best" database. I have not even seen any such argument on HN in like forever.<p>The reason Oracle makes so much money is not because they are best for some definition of best, but:<p>1. Lock in -> A database change is hard to do even for extremely focused tech companies. For companies whose core business is not technology, it might not even make sense to bother.<p>2. They expanded beyond the DB to acquire several companies like Peoplesoft and Netsuite and companies needing these inevitably turn to Oracle database.<p>Don't get me wrong, oracle has tons of Optimisations packed into it, but there is nothing which makes it the best database, or even an unambiguous top 3 databse product.
It is the best database if you are a bank, military or very large company who is already using it. Even in large government departments where I do contract work no one, absolutely no one, ever says "Why don't we use an Oracle database for our new application".
If you are a large company and pay enough in licensing fees you can get great support and it plays well with other Oracle acquisitions like PeopleSoft. Some of the support tooling is a nightmare to patch (looking at you OEM!).
MySQL allows you to group by a field and put other fields in the select. The value of those fields is some random value in one of the group rows. Oracle doesn't allow that crap. Oracle vs Postgres Oracle is faster and offers better security.<p><a href="https://www.dbmaestro.com/blog/database-automation/postgresql-vs-oracle" rel="nofollow">https://www.dbmaestro.com/blog/database-automation/postgresq...</a>
I'm not sure where you read or heard its the best database. There are equivalents out there for niche uses cases, including enterprise where there are other options that are far better.<p>Perhaps 25 years ago it was true.
Related: <a href="https://news.ycombinator.com/item?id=18442941" rel="nofollow">https://news.ycombinator.com/item?id=18442941</a><p>Fixing Oracle bugs, it's like a knightmare.