PostgreSQL - what is the _practical_ difference from MySQL in the context of a regular web application (forum, blog)?

Question

MySQL

I would like to understand this without really reading the docks and holivars:
- Is there any motive to make a new project on Postgre instead of the usual MySQL?
That is, there is a real practical meaning?
Or are they the same and it is better to work with what is more familiar?

Answer 1

If there is no difference, choose PostgreSQL. Because when the difference appears, you don't have to migrate.

Answer 2

I usually write DBMS-agnostic code (tests in sqlite in parallel, prod in MySQL), for me there is no difference.
MySQL performs better out of the box with minimal settings on a typical business project.
For you - depends on your tasks.