Chewbaccabra

@Chewbaccabra@lemmy.world

• ⁨Comment⁩ on ⁨Life isn't easy if your last name is 'Null' as it still breaks database entries the world over⁩ ⁨⁨4⁩ ⁨days⁩ ago⁩:

  Like you said, GIGO, but I can’t say I’m familiar with any csv looking like that. Maybe I’m living a lucky life, but true null would generally be an empty string, which of course would still be less than ideal. From a general csv perspective, NULL without quotes is still a string.

  If “NULL” string, then lord help us, but I would be inclined to handle it as defined unless instructed otherwise. I guess it’s up to the dev to point it out and not everyone cares enough to do so. My point is these things should be caught early.

  I’ll admit I’m much more versed in mysql than postgres.

• ⁨Comment⁩ on ⁨Life isn't easy if your last name is 'Null' as it still breaks database entries the world over⁩ ⁨⁨5⁩ ⁨days⁩ ago⁩:

  NULL != ‘NULL’

  How do devs make this mistake