I work on oracle dbs at a large non tech company. It is a great performant rdbms with poor tooling that I cannot believe they included for the licensing cost. Sqlplus could be great but totally isn’t good as a shell tool. Sqldeveloper is garbage. Python libraries and connection engines are solid for running anything automated. Dbeaver is a cool IDE alternative for clicking through tables.
From my experience across some MSSQL server, oracle, sqlite, and some non-professional postgres, the given database model trumps the underlying database tech when dealing with pains writing analytics reports. There are many options to mess up a model design or for feature extension to turn the model ugly.
Forget about building a new company on an oracle stack, the cost is prohibitive. The open source rdbms are very good and cloud providers have chosen their champions. But for a large legacy corporation with expensive, sensitive data, oracle makes sense. To an extent with a well trained dba the db is “self-documented”
Lol sometimes dbs aren’t exclusively used as a global web app backend for ultra scaling grocery delivery services or whatever. Sometimes db models persist for years and you need assurance that this tech is archival quality.
An aside, I think it’s funny the link you shared is a php site, another dinosaur!
>Absolutely it does. The number of new companies launching on Oracle rounds to near zero though.
I'm not sure how correct that is either, but it's incorrect to call it a legacy skillset on an unpopular technology. A good number of those new companies, if successful, get acquired and are forced to integrate if not convert to Oracle.
https://www.thomsondata.com/customer-base/oracle.php
That doesn't even include primarily government contract companies.