News for hackers. Stuff that matters.

A comment on We do not use foreign keys (2016).

Re:We do not use foreign keys (2016) by dylanz on Friday November 08, 2019 @05:16PM (#21487472)
Application vs Integration databases: https://martinfowler.com/bliki/IntegrationDatabase.html. If you're going to have one application writing to your database, having your constraints live in your application is definitely a viable option.
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by tiglionabbit on Friday November 08, 2019 @05:21PM (#21487532)
Not if you have multiple processes accessing the database simultaneously without some additional coordination layer.
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by randomidiot123 on Friday November 08, 2019 @06:06PM (#21487855)
It's definitely asking for trouble. Murphy's Law.
[ Parent | on HN ]