|
|
|
|
|
by ok_computer
930 days ago
|
|
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! |
|