News for hackers. Stuff that matters.

A comment on Do you really need foreign keys?. Parent comment

Re:Do you really need foreign keys? by shayonj on Thursday December 21, 2023 @12:50PM (#38723903)
That is great and I noticed it’s something I have always assumed should be the case - no indirect access to the database outside your application / ORM. Because then you open a can of worms.
[ Parent | on HN ]
Re:Do you really need foreign keys? by out_of_protocol on Thursday December 21, 2023 @01:33PM (#38724634)
Doesn't help much though. It only takes not wrapping related inserts into transaction in one place in your code. i know zero frameworks/ORMs that can help you with that
[ Parent | on HN ]
Re:Do you really need foreign keys? by tacone on Thursday December 21, 2023 @01:45PM (#38724844)
I usually wrap everything (including reads) in a transaction at middleware level. Not perfect, has its downsides but for many projects it's perfectly ok.

Of course it's not a real substitute for foreign keys, but definitely better than nothing.

[ Parent | on HN ]