News for hackers. Stuff that matters.

A comment on Things that don’t work well with MySQL’s FOREIGN KEY implementation. Parent comment

Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by Phelinofist on Monday May 01, 2023 @01:42PM (#35776392)
What's wrong with non-integer primary keys?
[ Parent | on HN ]
Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by takethisdownplz on Monday May 01, 2023 @02:00PM (#35776664)
besides performance for using something that is not often tested by devs working in performance, bad support for locale collating and open you for bugs such as indexing on email but allowing application to store both upper and lower case etc.
[ Parent | on HN ]
Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by evilspammer on Monday May 01, 2023 @03:08PM (#35777598)
I would expect they're referring to UUIDs or something
[ Parent | on HN ]
Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by tomnipotent on Wednesday May 03, 2023 @04:52AM (#35799730)
You can pack fewer of them into a page, which means more disk IO for things like index scans.
[ Parent | on HN ]