valtia

@valtia@lemmy.world

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨5⁩ ⁨days⁩ ago⁩:

  in this case you would just overwrite the existing row, you wouldn’t use de-duplication because it would do the opposite of what you wanted in that case.

  … That’s what I said, you’d just update the row, i.e. replace the existing data, i.e. overwrite what’s already there

  Definitionally, the actual identity of the person MUST be unique, otherwise you’re going to somehow return two rows, when you call one, which is functionally impossible given how a DB is designed.

  … I don’t think you understand how modern databases are designed

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨6⁩ ⁨days⁩ ago⁩:

  i genuinely cannot think of a single instance where you would want to delete one entry, and replace it with a reference to another

  Well, there’s not always a benefit to keeping historical data. Sometimes you only want the most up-to-date information in a particular table or database, so you’d just update the row (replace). It depends on the use case of a given table.

  what elon is implying here (remove “duplicate” entries, however that’s supposed to work)

  Elon believes that each row in a table should be unique based on the SSN only, so a given SSN should appear only once with the person’s name and details on it. Yes, it’s an extremely dumb idea, but he’s a famously stupid person.

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨6⁩ ⁨days⁩ ago⁩:

  There can be duplicate SSNs due to name changes of an individual, that’s the easiest answer. In general, it’s common to just add a new record in cases where a person’s information changes so you can retain the old record(s) and thus have a history for a person. That’s how the SSA is able to figure out if a person changed their gender, they just look up that information using the same SSN and see if the gender in the new application is different from the old data.

• ⁨Comment⁩ on ⁨Looks legit, but can it actually be a real thing?⁩ ⁨⁨1⁩ ⁨week⁩ ago⁩:

  Conservatives would just blame it on DEI and it somehow being funded by USAID

• ⁨Comment⁩ on ⁨[deleted]⁩ ⁨⁨4⁩ ⁨weeks⁩ ago⁩:

  Image

• ⁨Comment⁩ on ⁨This world is cruel…⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  that’s exactly the point. taking a picture won’t kill you, and it sets you apart from all of the other men who are so stubborn that they refuse

• ⁨Comment⁩ on ⁨Anon has nerdy hobbies⁩ ⁨⁨9⁩ ⁨months⁩ ago⁩:

  I second this. There are some really great Discord communities to play on that I’m part of. Generally, it’s much easier to keep the creeps out by just banning them. It doesn’t have to be a Westmarches server, but any TTRPG server with an actual community that runs game on the server itself, instead of just another LFG fishing pond.