PostgreSQL is really better at executing arbitrarily complex queries, and the documentation is so much better. PostgreSQL also provides additional features lik

PostgreSQL is really better at executing arbitrarily complex queries, and the documentation is so much better. PostgreSQL also provides additional features like LISTEN/NOTIFY, Row Level Security, transactional DDL, table functions (like generate_series), numbered query parameters ($1 instead of ?), and many others. In my opinion, the only reasons for choosing MySQL/MariaDB are if you absolutely need clustered indexes (also known as index organized tables — PostgreSQL uses heap organized tables) or if you architecture relies on specific MySQL replication features (for example using Vitess to shard your database).