!rant PostgreSQL or MySQL/MariaDB?

I use Postgresql and would recommend it

I use maria and i have mixed feelings

I use MariaDB usually for PHP , pgsql for RoR

I'm developing in PHP, I'm interested in Postgres because of its schemas which allow me to better organize my large DBs, I also really like its support for NoSQL inserts which can come in handy for some of my data.

its major problems for me come about due to a lack of really good GUI tools like SequelPRO, and it's slower performance when compared to InnoDB

@jonnyserra it has pgAdmin and phppgAdmin which are GUI programs.
furthermore, u can manage it from IDEs like DataGrip or PhpStorm.

I also has a nice C and C++ interface

I used PostgreSQL after coming from MSSQL and found it annoying. It could have just been the management software, though.

MySQL and MariaDb started diverging and become more separate, feature and api / syntax wise.

Both do their job good and, in very recent versions, started implementing windowing functions, recursive and so on, gaining SQL features that were long time missing. Growing up you could say.

On the other hand, MySQL QA has gotten so worse that I do not recommended it for enterprise usage. Take a look at Percona in that regard - MySQL done right.

PostgreSQL is a DBAs wet dream I guess... PostgreSQL does not focus on being simple, instead it focuses on being feature rich in the good sense. When u have a good understanding of databases and algorithms, then PostgreSQL is your multi dimensional swiss army knife that can cut through butter or melt a planet, as u wish. :) so: a lot of features in every detail possible (indexes, sort algorithms, optimization and so on), that allows very precise control over what and when. If u know what u are doing.