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 rhinoceraptor on Friday November 08, 2019 @05:30PM (#21487615)
I had a job where the database was intentionally lacking FKs so that users could input data out of order, for example create a shipping route Foo that goes to a warehouse Bar, before the warehouse existed. Let's just say it was a suboptimal design.
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by redact207 on Friday November 08, 2019 @07:06PM (#21488359)
this just sounds like eventual consistency which can form part of a perfectly optimal design
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by Lord_Zero on Friday November 15, 2019 @11:13AM (#21546005)
Or "eventual" never comes and you end up with a bunch of inconsistent data.
[ Parent | on HN ]