News for hackers. Stuff that matters.

A comment on Ask HN: It's 2023, how do you choose between MySQL and Postgres?. Parent comment

Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by paulddraper on Thursday May 11, 2023 @07:14PM (#35909623)
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=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/

[ Parent | on HN ]
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by digitalpacman on Sunday May 14, 2023 @03:27AM (#35936092)
Good you shouldn't be using them. You shouldn't be using foreign keys either. It just makes working with data harder and doesn't help with constraining it if your data modifications are inside transactions and properly written statements.
[ Parent | on HN ]