They used to sell a pretty good (if complex) database system. However it hasn’t been popular for many years. I assume they still have big customers who are locked in.
These days they’re just another amorphous “cloud service provider”, and not a good one either.
I work with a client using an Oracle DB. You have to do multiple request to even do something basic as pagination 😂.
They improved it over the years, but given the choice, I’d advice for anything else than Oracle. I’d even prefer MS Sql, which, given I’m pretty anti-MS, is a miracle.
They are doing something wrong. Say what you want about their commercial strategy, the product itself is pretty good. It can definitely do pagination, and I hope they are not doing skip and limit.
Yeah, you can do pagination, but you need two request : one to select everything, the second to only return the results between id x and id y. Needless to say, the performances are far from ideal.
But in recent version you do skip and take x, which is far easier to write. But my codebase date back to the 2000’s, and it uses the old ways.
As an example, an SQL request to filter on an handful of parameters, and paginate, easily amount to 40-50 lines of SQL. And that’s the easy ones, because some request uses multiple view, in which case I wouldn’t be surprised to find a request doing more than 100 lines of SQL, maybe without even factoring the view in.
That’s some funky code, pagination is much easier than that, unless there’s something else going on.
It hasn’t been popular? I guess you mean “cool” or “trendy” but well more than half of enterprise applications work on oracle, closer to 75% in fact.
Yes, plenty of companies are exiting oracle but it will still dominate for at least a decade. Sometimes there’s just no good equivalent, and no, Postgres cannot compare even tho it’s a great DB for many use cases.
jj4211@lemmy.world 1 day ago
In IT the golden rule is regardless of technical media, you do not want a business relationship with Oracle under any circumstances.
They will use that foot in the door to make your life hell with audits and invoicing crap you never bought.