Re:Ask HN: Is PostgreSQL better than MySQL?
by sam_lowry_ on Monday April 17, 2023 @12:07PM
(#35602784)
Hah, I always felt the same about Postgres and I still prefer the MySQL cli.
The concept of schema is also weird for MySQL users.
I can understand it being weird, but when you get used to it, it's really really handy, for instance to manage user rights. I've read somewhere that actually, pg schemas compares more with mysql database, postgresql databases being an additional level wrapping it.
Re:Ask HN: Is PostgreSQL better than MySQL?
by sam_lowry_ on Saturday April 29, 2023 @03:46PM
(#35756440)
Exactly, every sysadmin wants to manage user rights in his own ingenious way through schemas.
Coming from Oracle, I've been able to use PostgreSQL pretty much as though it were Oracle, including Oracle's optimistic locking strategy. Some of the SQL functions are a little different, but it seems the underlying philosophy is the same. In other words, PostgreSQL seems like Oracle, just a little different.
MySQL has always felt completely foreign to me. Depending on your background and familiarity with other RDBMS's though, you may be right at home with it. Wouldn't be a bit surprised if someone had a similar anecdote to mine replacing PostgreSQL with MySQL and Oracle with SQL Server.
If you don't have a personal preference for either system then do some benchmarking on the platform you'll be running them on and the loads you're expecting and see if either particularly excels over the other for what you're intending to do.