3 ms·
Here's my experience with PostgreSQL: Coming from Oracle, I've been able to use PostgreSQL pretty much as though it were Oracle, including Oracle's optimistic
by taylodl 4y ago
Here's my experience with PostgreSQL:
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.
- sam_lowry_ 4y agoHah, I always felt the same about Postgres and I still prefer the MySQL cli. The concept of schema is also weird for MySQL users, although pervasive in some kind of Michael Stonebreaker' worldview.
- autra 4y agoI 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.
- sam_lowry_ 4y agoExactly, every sysadmin wants to manage user rights in his own ingenious way through schemas.