3volver@lemmy.world to Ask Lemmy@lemmy.world · 8 months agoWhat's something you believed to be true but recently learned is actually false?message-squaremessage-square108fedilinkarrow-up185arrow-down13
arrow-up182arrow-down1message-squareWhat's something you believed to be true but recently learned is actually false?3volver@lemmy.world to Ask Lemmy@lemmy.world · 8 months agomessage-square108fedilink
minus-squareinvertedspear@lemm.eelinkfedilinkarrow-up28·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-squaretowerful@programming.devlinkfedilinkarrow-up3·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.
Or nullable FK , with on delete set null.
Or have a default value for the FK, and on delete set default.
Relevant xkcd