4 ms·
That and why not allow null for the foreign key constraint and set it to nullify upon deletion? Or indeed, anonymise data.
by unicornfinder 6y ago
That and why not allow null for the foreign key constraint and set it to nullify upon deletion? Or indeed, anonymise data.
- sopooneo 6y agoI have used that pattern in my apps and found it works well. But then I've watched video from respected DB experts, that I learn a great deal from, where they practically beg you to stop using nullable columns. So I'm torn, because I think there may just be a major problem I've not yet grown my apps big enough to suffer. Anyone have thoughts either way?
- dmux 6y agoAny particular videos you'd recommend?