I chose PostgreSQL over MySQL quite some time ago, deciding that it was
MUCH easier to set up from scratch and that is was more compliant with
the SQL standard than was MySQL (specifically, MySQL). Regardless of
the marketing, MySQL had a few distinct disadvantages, which irritated
me early on, not the least of which is the way it handles things like
embedded quote marks in string data.

That being said, a former Oracle employee has apparently gone on the
record with a similar opinion, having been a member of a team tasked
with improving MySQL.

https://www.theregister.com/2021/12/06/mysql_a_pretty_poor_database/

"Coming to MySQL was like stepping into a parallel universe, where there
were lots of people genuinely believing that MySQL was a
state-of-the-art product."

"The changes others and I have been doing take the MySQL optimizer
towards a fairly standard early-2000s design with some nice tweaks, but
that's also where it ends."

"In the end, there's just not enough resources that I could see it turn
into a competitive product, no matter how internal company
communications tried to spin that Oracle is filled with geniuses and WE
ARE WINNING IN THE CLOUD."

and...

<quote>
Gunderson was also scathing of this. "Don't believe for a second that
MariaDB is any better [than MySQL]. Monty and his merry men left because
they were unhappy about the new governance, not because they suddenly
woke up one day and realised what a royal mess they had created in the
code."
</quote>

and there's also THIS guy:

<quote>
Roland Hörmann, CEO SIB Visions, who presented at Postgres Build 2021
last week, spoke specifically about migrating from Oracle's proprietary database to PostgreSQL.

"You can get support if need it. If you set up a database, you configure
once the PostgreSQL conf file and then it's up and running forever, to
be honest. You don't need to do anything. True, you need to set up a
backup and all that stuff, but you don't need so much time from
experienced DBAs anymore."
</quote>

more in the article, these only being hilights.


(and I'm glad to see people agree with me about setting up PostgreSQL
being so much easier than would be MySQL and others - in fact I set up a
test database last week and just had to remember which config file to
edit to allow access outside of localhost - and it was well documented
online)


--
(aka 'Bombastic Bob' in case you wondered)

'Feeling with my fingers, and thinking with my brain' - me

'your story is so touching, but it sounds just like a lie'
"Straighten up and fly right"

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)