Chewbaccabra
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.
NULL != ‘NULL’
How do devs make this mistake
Lol it’s actually very important to watch it without dubs. The show is filled with people interacting who don’t speak the same language, which makes it interesting. Dubs ruin that. Netflix in their wisdom defaulted to dubs, and fortunately I learned to correct that after about three episodes.
I don’t know anything about economics but this is an interesting and recent Chapo podcast on the topic: https://youtu.be/rq5vxvS615Y
Iirc they say putting an embargo on countries will cause a cascade with all banks that use USD. They extend this to suggest that the US has sanctioned a third of the planet overall.