On: Ask HN: Do you use foreign keys in relational data...

[axylos]

> Your coworkers argument about FKs making data migrations difficult is one of them.

Got any arguments to back up this bald assertion?

In particular, I'd love to hear more about how to manage schema migrations on large tables with FK's without incurring lengthy locks or downtime.

Betting the answer is going to involve some variation on "well, don't do that" which is when I'll rest my case.

[roguas → axylos]

There are tools for live migrations for most popular databases. Also a lot of Postgres DDL is very fast and/or capable of happening live.