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 SkyPuncher on Thursday December 21, 2023 @03:03PM (#38726048)
Context is key.

If you have an established business or startup, data will outlive the application. However, you need a product that lives long enough for either data or application to matter.

In the startup world, that means making decisions that help you ship now, at the expense of debt/costs down the road.

[ Parent | on HN ]
Re:Do you really need foreign keys? by mavelikara on Thursday December 21, 2023 @06:28PM (#38728617)
IME, Foreign Keys do not slow down development velocity, after you factor out the upfront time investment it takes to understand them, normal forms, and other RDBMS concepts. Other posters in this thread have argued that they take CPU cycles during program execution - which is factual correct.
[ Parent | on HN ]