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 dragonwriter on Monday May 01, 2023 @02:00PM (#35776661)
Its a shortcut to support use of a denornalized schema where, in a properly normalized schema, there’d be abother table where the row was unique.
[ Parent | on HN ]
Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by dllthomas on Monday May 01, 2023 @03:16PM (#35777716)
Always use a nornalized schema. The ability to see the future is invaluable in a database.
[ Parent | on HN ]