The secure CMS.
Welcome to Geeklog Tuesday, January 17 2017 @ 10:08 am EST
1/1: What Database System do you prefer?
The following comments are owned by whomever posted them. This site is not responsible for what they say.
If anyone interested please email me.
I have had that experience. Initially, PG seemed to have too much unneeded complexity, the configuration was a bit more esoteric (hey we are talking DBMS's here :-) and many of the non-INSERT/UPDATE/SELECT commands were different.
But things like transactions are actually massively more useful that some MySQL advocates would make out. You don't need to be writing a banking application to make transactions extremely useful. Sequences also are a lot more useful than AUTO INCREMENT.
Interesting reading on the pros and cons can be found in this PHPBuilder article. Keep in mind that since that article, many improvements have happened to postgres, including the abolishment of the 8K row limit (I beleive) and stability is now rock-solid. Performance is now right up there too.
I still have lots of respect for MySQL, and I'm using it for my current DB-Driven project. It's speedy, lightweight, and in this particular case it does everything I need.