DEV Community

Discussion on: What is your favorite database?

Collapse
 
joelbonetr profile image
JoelBonetR 🥇 • Edited

While the inner complexity differs, the experience using one or another is almost the same.

MySQL or MariaDB (which is a community fork of MySQL that branched out a bit) are meant for fast sort of little projects. PostgreSQL is meant for robust high reliable business-driven projects. It comes with much better tooling such PGAdmin 4.

I don't know the current state but MySQL usually showed up issues with concurrency while the Postgres way to deal with that avoid that issue at any scale.

In little projects it's difficult for the postgre benefits to show off but sure, you can stick into PostgreS for all sort of projects where you need relational DB. The only difference is that postgre is a little bit heavier by default, just that.