> So any time you want to get all the CHILDREN of a PARENT you have to query all children to see if they have a FK to the appropriate PARENT.
It's just an index lookup, so what? You'd rather mash all the data into a single parent field, is that it?
It's just an index lookup, so what? You'd rather mash all the data into a single parent field, is that it?
I think it's more about the expressivity of pointers and arrays compared to the "backwardness-feeling" of index lookups.
> I think it's more about the expressivity of pointers and arrays compared to the "backwardness-feeling" of index lookups.
Greater expressivity in ways to store bad data is never a good thing.