Phoenix.pm: "Why Not To Use Foreign Keys" ?

Bill Lindley wlindley at wlindley.com
Wed Apr 21 09:14:53 CDT 2004


...linked from a Slashdot thread, it's the MySQL developers eating 
humble pie... funny reading in a 'cvs commit' diff..

---begin quote---
- at cindex foreign keys, reasons not to use
+ at cindex foreign keys, why not implemented

-There are so many problems with foreign key constraints that we don't
-know where to start:
+Many database scholars and programmers feel very strongly that
+referential integrity should be enforced inside the database server.
---end quote---

much more at

http://lists.mysql.com/internals/1771




More information about the Phoenix-pm mailing list