News for hackers. Stuff that matters.

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

Re:We do not use foreign keys (2016) by asdkhadsj on Friday November 08, 2019 @04:51PM (#21487224)
A neat idea for sure. However I'd be concerned that suddenly you have two different applications. Example, if you delete a row with a cascading deletion elsewhere, that will work on dev, but on prod it would leave dangling data.

Though, I imagine you could simply not use cascading behaviors.. Neat idea though. Scary, but neat hah.

[ Parent | on HN ]
Re:We do not use foreign keys (2016) by jagged-chisel on Friday November 08, 2019 @07:12PM (#21488404)
No DELETEs - it's banking!

But seriously, there are a host of issues one must overcome for this plan to work. And there were indeed managed permissions for DELETE. But ultimately, I wasn't aware of much of the implementation detail ...

[ Parent | on HN ]