alt Hacker NewsI don't love Oracle, but they made so much money selling the best relational database on the planet for 40 years.
Replies
We must have extremely different definitions of what constitutes "best" or even "good"
Uh, it's only the "best" in the same sense that Windows Server is the best server infra on the planet. And arguably Windows has some network bandwagon effect behind its momentum: when your workstation supplier supplies machines with Windows pre-installed and you have built an IT Support Team with the expertise for Windows technologies, it only makes sense to also use Windows in your server.
AFAICT the only thing Oracle has over established FOSS DBs is vendor support and the only thing Oracle has over established FOSS vendors like Percona is a ginormous marketing budget. I'm always grimused when I see Oracle product placement in the MCU.
OracleDB, MongoDB and PHP over IIS natively on a single Windows machine running on Azure. Delicious.
"The best", but you'll be sued if you publish benchmarks: https://en.wikipedia.org/wiki/David_DeWitt#DeWitt_Clause
Every time I use Oracle, I regret it.
Just this month, I tried to hook it up to a modern .NET app with the latest Oracle client and discovered that if you cancel a transaction, the connection enters a broken state and is returned to the connection pool, "infecting it". After a half a dozen of those, the whole app server just dies with endless cancellation related exceptions. This isn't even the only such bug, apparently there's a whole family of pool-corruption bugs that have workaround config settings and everything!
This was with version 23.26.301 which suggests that they've had a lot of major releases, bug fixes, etc... but basic functionality like "connect successfully to the database server every time" is totally broken and has been for many years.
The issue tracker forums have tumbleweeds rolling through them and play the sound of wolves howling in the distance to provide just the right kind of "what are you still doing here?" ambiance.
> best relational database
Hard disagree. Oracle's database will always live in my mind as a complete waste of money. Some con-man, I'm sorry salesman, sold a previous (idiot) executive on it at a previous company I worked for. The exec was long gone and lots of time was wasted trying to adapt our application (that used MySQL) over to Oracle until we finally pulled the plug. But not after spending hundreds of thousands of dollars on time and equipment. We re-purposed the hardware into effectively a big NAS.