Lol my company is paying a fortune to get off oracle. Anyone that does not need the million features that come with a oracle will eventually move off it. It's way too expensive to use in smaller environments or non mainframe environment's. Oracle has some of the worst pricing and sales techniques.

That really depends on how much weight the "oracle" part of her experience has. Oracle has tons upon tons of customized tools, language add-ons/plugins, and quirks. The SQL part of Oracle might translate (more or less) to Postgres easily, but these other things are unlikely to.

Absolutely it does. The number of new companies launching on Oracle rounds to near zero though.

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!