One thing that bit me on MySQL is that triggers don't execute on cascade deletes/updates: https://bugs.mysql.com/bug.php?id=11472 https://bugs.mysql.com/bug.php

One thing that bit me on MySQL is that triggers don't execute on cascade deletes/updates: https://bugs.mysql.com/bug.php?id=11472 https://bugs.mysql.com/bug.php?id=11472 That issue was filed in 2005 and it still isn't fixed. Another gripe I have is that MySQL's JSON Path capabilities are much more limited than the Postgres JSON Path capabilities. MySQL doesn't have filter expressions nor any operators/methods but Postgres does. Don't get me wrong, neither is jq, but I hate having to jump through extra hoops to get my JSON in the right format. Compare https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH https://www.postgresql.org/docs/current/functions-json.html#... and https://dev.mysql.com/doc/refman/8.0/en/json.html#json-path-syntax https://dev.mysql.com/doc/refman/8.0/en/json.html#json-path-...