|
|
|
|
|
by mdnormy
3185 days ago
|
|
Familiarity? MySQL/MariaDB is pretty much the "standard" database that most programmer started with. At least in university. So there is no point on using PosgreSQL if MariaDB fits the bill for them. Less learning curve, easy to hire for etc |
|
* you can configure triggers for a table, but you can't use them in MySQL unless you make sure the table is InnoDB (this was a while ago before defaults changed)
* MySQL doesn't support aborting INSERT/UPDATE/DELETE from trigger, but you can emulate it by throwing an exception
* a table can have a CHECK constraint, but you can't use it because it is not available in MySQL
Makes one wonder MySQL was picked for that class. I get that it was because it was very popular at the time, but it felt like a toy compared to a functionality that any other database had.