Which DBMS to choose as an alternative to MySQL?

Question

Database

I made a couple of sites in PHP / MySQL (one is pure PHP, a database via PDO, the other is on Symfony 3 with ORM Doctrine), now I'm planning a new project (for a portfolio) on the Laravel framework (Eloquent ORM) , well, I want to try another DBMS at last. The site is a small information portal with articles, news, comments and a photo gallery.
I have been looking at PostgreSQL for a long time, but a friend who works as a JS developer said, they say, only MongoDB. So I think which DBMS is more in demand today, what should I study.
I want something that can be easily installed on both Windows and CentOS.

Answer 1

Don't listen to your friend. PostgreSQL/MySQL is a good and time tested solution.
You don't have to chase fashion.
I read from various sources that PostgreSQL is more productive than MongoDB, as well as a more reliable solution.
Although it will not be harmful to read about NoSQL.

Answer 2

In general, either you did not understand your friend, or he does not know what he is talking about. MongoDB has a different working paradigm and is better suited to other tasks than MySQL/PostgreSQL.

Answer 3

I use MySQL, PostgreSQL, MSSQL. The list is not complete, of course. The first two were also used for applications with a high load, where many users and a large data stream can work in parallel.
Feel free to use both MySQL and PostgreSQL - but most importantly, don't trust the default settings. By default, these databases are configured to run on 99% iron - shaky rolls, but they will work. But in order for them to work quickly, you need to configure them.