3volver@lemmy.world to Ask Lemmy@lemmy.world · 7 months agoWhat's something you believed to be true but recently learned is actually false?message-squaremessage-square109fedilinkarrow-up186arrow-down13
arrow-up183arrow-down1message-squareWhat's something you believed to be true but recently learned is actually false?3volver@lemmy.world to Ask Lemmy@lemmy.world · 7 months agomessage-square109fedilink
minus-squareinvertedspear@lemm.eelinkfedilinkarrow-up28·7 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-squaretowerful@programming.devlinkfedilinkarrow-up3·7 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.