DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Discussion on: What is your favorite database?

Collapse
cipharius profile image
Valts Liepiņő

I'm wondering why do you suggest MariaDB(MySQL) for small scale project over Postgres?

Don't have that much hands on experience with MySQL like databases, but i felt like Postgres isn't much more complex, if one sticks to basic features.

Collapse
joelbonetr profile image
JoelBonetR • Edited on

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.