Operating without foreign key constraints (opens in new tab)

(docs.planetscale.com)

21 pointsKwisaksHaderach4y ago2 comments

2 comments

I have encountered the problems described for MySQL with Oracle and DB2 databases. If you implement the business rules as transactions within stored procedures, then the logical constraints can be maintained programmatically by the StoredProcs.

errcorrectcode4y ago

As long as the constraints are maintained within the DB correctly, it's cool. Some constraints are more complicated than FK constraints allow. Implementing as close to the DB as possible is a good idea.

To do it in app code would be a terrible idea because it throws FK referential (and data) integrity out the window.

j / k navigate · click thread line to collapse

2 comments

GianFabien4y ago

errcorrectcode4y ago

To do it in app code would be a terrible idea because it throws FK referential (and data) integrity out the window.

j / k navigate · click thread line to collapse