Not even super massive like amazon, even an app for a few million users you’ll run into the performance problems of FKs. They are really overrated in their us

Not even super massive like amazon, even an app for a few million users you’ll run into the performance problems of FKs. They are really overrated in their usefulness - as parent says, orphan records are really not a big deal. As soon as you get to any moderate scale, dealing with a small level of data inconsistencies is inevitable. Especially as you grow into a multiple services, multiple databases type architecture where you fundamentally have to handle breaking fks btw systems