@3volver to Ask Lemmy • 8 months agoWhat's something you believed to be true but recently learned is actually false?message-square109arrow-up186arrow-down13
arrow-up183arrow-down1message-squareWhat's something you believed to be true but recently learned is actually false?@3volver to Ask Lemmy • 8 months agomessage-square109
minus-square@[email protected]linkfedilink28•8 months agoI love how this comment covers super common misconceptions, but then throws a super specific database issue in at the end. Gotta have that cascade on delete, unless you want orphans.
minus-square@[email protected]linkfedilink3•8 months agoOr nullable FK , with on delete set null. Or have a default value for the FK, and on delete set default.
I love how this comment covers super common misconceptions, but then throws a super specific database issue in at the end. Gotta have that cascade on delete, unless you want orphans.
Relevant xkcd
Or nullable FK , with on delete set null.
Or have a default value for the FK, and on delete set default.