You can login if you already have an account or register by clicking the button below.
Registering is free and all you need is a username and password. We never ask you for your e-mail.
MySQL has a good number of creature-comfor featurse. For example, the "UPSERT" command has been with MySQL for a decade. MySQL also has had the "REPLACE" command which will either add a new row, or replace one if the values you're passing match an existing row's primary key.
MariaDB has support for working with JSON directly, though I don't know why you'd do this at the database level unless you absolutely had to. Probably makes more sense at the app level.
MySQL can operate in a strict mode where it will complain about truncated values or bad dates more vocally. (By default, it generates warnings, in strict mode, it will error.)
One of the things that really took me by surprise with Postgres is how rigid it is. For example, there is no good way to join tables from two different databases, even if they are on the same server. Actually, I think you can do it with federated databases now, but it's still a bunch of hoops to jump through. With MySQL the syntax is straightforward, the only drawback is that the user doing the query must have the right permissions for both.
There's lots of little differences like this (and big ones, too). At this point, I don't even know if it makes sense to try to compare them. For your purposes, either is most likely going to do the job and then some.
view the rest of the comments →
[–] Drenki 0 points 1 point 1 point (+1|-0) ago (edited ago)
Pretty much all of this goes for either MySQL or MariaDB.
One of the things that really took me by surprise with Postgres is how rigid it is. For example, there is no good way to join tables from two different databases, even if they are on the same server. Actually, I think you can do it with federated databases now, but it's still a bunch of hoops to jump through. With MySQL the syntax is straightforward, the only drawback is that the user doing the query must have the right permissions for both.
There's lots of little differences like this (and big ones, too). At this point, I don't even know if it makes sense to try to compare them. For your purposes, either is most likely going to do the job and then some.