Comment Comment by paulddraper FWIW, it hasn't changed in ten years.Here is an 18-year-old bug, that DELETE triggers don't work for foreign key cascades: https://bugs.mysql.com/bug.php?id=11472That makes the entire feature mostly worthless. Reported in 2005, last updated in 2008.---While I would choose PostgreSQL every time, MySQL has the following advantages:1. Write-performance, due to fundamental design tradeoffs. [1]2. Per-connection resources, due to single-process design.3. Related to #1, no vacuum requirement.[1] https://www.uber.com/blog/postgres-to-mysql-migration/ parent paulddraper 3 years ago
Here is an 18-year-old bug, that DELETE triggers don't work for foreign key cascades: https://bugs.mysql.com/bug.php?id=11472
That makes the entire feature mostly worthless. Reported in 2005, last updated in 2008.
---
While I would choose PostgreSQL every time, MySQL has the following advantages:
1. Write-performance, due to fundamental design tradeoffs. [1]
2. Per-connection resources, due to single-process design.
3. Related to #1, no vacuum requirement.
[1] https://www.uber.com/blog/postgres-to-mysql-migration/