Things that don’t work well with MySQL’s FOREIGN KEY implementation

Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by AugustoCAS on Monday May 01, 2023 @03:08PM (#35777594)

I have the strong feeling I would never do this regardless of the DB engine for performance and storage reasons. I would try to hash the blob into a bigint and use that as the PK/FK.

Out of curiosity, is there a scenario you can share in which using a binary blob as a PK/FK would be the best solution?

[ Parent | on HN ]

Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by ComputerGuru on Monday May 01, 2023 @04:57PM (#35779037)

I'm not talking huge blobs, just (fixed-size) 8- to 16-byte uuid-like fields. You can obviously marshal 8-byte fields to a bigint but you can't do that with 16-byte fields.

[ Parent | on HN ]