What beam base is suitable for a working portal?

Question

MySQL

Good afternoon! Now the developers are writing a portal like headhunter, the moment is very acute, which database to choose postgrep or mysql, what would you choose, justify your point of view.
Another question is, if Mysql is installed for me, how difficult will it be to switch to PostgreSQL later, and is it worth switching at all?

Answer 1

Now developers are writing a portal

Ask the developers what DBMS they know best. And ask your admins what DBMS they know better. You clearly do not have a DBA, otherwise the question would not have been so.
headhunter itself uses postgresql. But they have their own team of admins, and in addition, an experienced DBA team of my current colleagues, who specialize specifically in postgresql.
I know both DBMS quite well from a developer's point of view, but I do not know how to administer mysql, so my opinion will be biased.
If you are doing a commercial project, then use the DBMS that your team knows best. If the developers hide behind their ORMs and don't look into the database, then it doesn't matter, in such conditions any DBMS will work equally badly. If at least someone in the team understands what needs to be done with the base, entrust the choice to him and ask about the reasons for the choice.

Answer 2

Take MongoDB. There will be no scalability and performance issues.
The concept of a site with vacancies / positions fits perfectly into the NoSQL storage.