How do devs make this mistake

it can happen many different ways if you’re not explicitly watching out for these types of things

example let’s say you have a csv file with a bunch of names

id, last_name
1, schaffer
2, thornton
3, NULL
4, smith
5, "NULL"

if you use the following to import into postgres

COPY user_data (id, last_name)
FROM '/path/to/data.csv'
WITH (FORMAT csv, HEADER true);

number 5 will be imported as a string “NULL” but number 3 will be imported as a NULL value. of course, this is why you sanitize the data (GIGO) but I can imagine this happening countless times at companies all over the country

there are easy fixes if you’re paying attention

COPY user_data (id, last_name)
FROM '/path/to/data.csv'
WITH (FORMAT csv, HEADER true, NULL '');

sets the empty string to NULL value.

example with js

fetch('/api/user/1')
  .then(response => response.json())
  .then(data => {
    if (data.lastName == "null") {
      console.log("No last name found");
    } else {
      console.log("Last name is:", data.lastName);
    }
  });

if data is

data = {
  id: 5,
  lastName: "null"
};

then the if statement will trigger- as if there was no last name. that’s why you gotta know the language you’re using and the potential pitfalls

now you may ask – why not just do

if (data.lastName === null)

instead? But what if the system you’re working on uses JSON.parse(data) and that auto-converts everything to a string? it’s a very natural move to check for the string "null"

obviously if you’re paying attention and understand the pitfalls of certain languages (like javascript’s type coercion and the particularities of JSON.parse()) it becomes easy but it’s something that is honestly very easy to overlook

i think the only way we can survive and create a successful egalitarian society is by having some sort of overlord ruling over us

so for example let’s say we write a constitution and then have a super-powered generalized artificial intelligence machine force us to follow the rules

or aliens. we could become pets for alients https://www.youtube.com/watch?v=RgPeP_pfjp4

I mean, Bannon started this whole thing. He was pushed out of the inner circle but he was the one with the vision back in 2016.

Bannon is a visionary and he had the right idea. He just didn’t have the ability to execute. Trump took the ideas from Bannon and found new allies who have the ability to execute. Musk (and Thiel) were more than happy to jump on board

Edit: just in case it’s not clear I’m not endorsing his views. I am firmly anti-Nazi

look there was no plausible deniability when Elon did it. He pretended like he was a weirdo autist the night of with his weird head bobbing and his exaggerated gestures to try and give plausible deniability. but the Nazi salute was putting the toe in the water. feeling the room

it seems that the wannabe Nazis felt like the water was warm enough and they’re gonna start descending the staircase into the pool