I have to admit though, I've never admined the Oracle DB, but I did talk a lot with people who did.
I remember over 10 years ago discussing transactional DDLs as I heard Oracle does it, too, just to listen to 5 minute lecture about how it's nowhere near as simple.
Yeah, that was the goal.
First make it feature-complete document-oriented database, then make if peroformant.
And you can feel the benefits in every step of the way. Things just work, features actually complement each other... and there's always a way to make any crazy idea stick.
If you can, share your experience!
I also do finance, so if there is anything more to explore, I'm here to listen and learn.
I made several lengthy presentations about many features, mainly those that are/were missing in MySQL.
In short, MySQL (has been) shit since its inception, with insane defaults and lacking SQL support.
After Oracle bought it, it got better, but it's catching up with stuff that Postgres has had for 20+ years (in some cases).
Also, fuck Oracle, it's a shit company.
Edit: if I had to pick the best features I can't live without, it would be 'returning', copy mode and arrays
AI? Absolutely can be.
LLMs specifically? No thanks.
There is no ethical consumption under capitalism.
Injustice anywhere is a threat to justice everywhere.
We can nitpick specific examples for everything you want, and we will be correct, but that detracts from the point that Gabe has helped to build things that took decades of slowly getting anywhere.
I wish we didn't need it, but we do.
This is literally me at every possible discussion regarding any other RDBMS.
My coworkers joked that I got paid for promoting Postgres.
Then we switched from Percona to Patroni and everyone agreed that... fuck yes, PostgreSQL is the best.
Many (probably most) jobs are bullshit jobs just to make the economy roll.
If we skipped the middleman, and just fed everyone, we would cost environmental costs by 90%.
Everyone here throwing shade...
but I feel like a jester in every company.
They pay me money to show up and entertain the owner/shareholder/managers shit. And I do.
That's oddly specific...
This is how democracy dies... with people willingly surrendering it.
Yes, had those issues as well, though lately not a big corp, but mid-sized company.
One manager just wanted MySQL. We had trouble getting required performance from MySQL, when Postgres had good numbers. I had the app fully ready, just to be told no, you make it work in MySQL. So we dropped some 'useless stuff' like deferring flushing to disk and such.