turtle

@turtle@lemm.ee

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

  Good to know, thanks. I haven’t worked with btrfs much yet. I have ZFS on a Debian server.

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

  There’s an old saying with ZFS: “Friends don’t let friends dedupe”

  That’s a bad example to reference. The ZFS implementation of deduplication is poorly thought out, and I say that even though I like and run ZFS on my own Linux server(s). I understand that the BTRFS implementation of dedupe works well (no first-hand experience), and the Windows one works great (first-hand experience).

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

  Oh, I hear you!

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

  I can definitely imagine all that. Thanks!

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

  I don’t envy either party either. You’re welcome!

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

  I don’t have any resources handy, but I do know someone who this happened to: they were an immigrant who got an SSN the first time they migrated to the US, went back to live in their country for a number of years, then returned to the US and I guess applied for an SSN again. Voilá, two SSNs and a mess.

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

  That all makes sense, except if someone’s SSN changes (which happens under certain circumstances), doesn’t that invalidate their primary key or require a much more complicated operation of issuing a new record and relinking all the existing relationships?

  I can imagine an SSN existing in more than one primary key due to errors. If they use SSNs in the primary key at all, but combined with something else, that leads me to believe that the designers felt that SSNs were reliable for being a pure primary key.

  I agree with you about Occam’s Razor. The guy has demonstrated multiple times that he’s a dishonest moron.

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

  I saw a comment about this in the last couple of days that was really interesting and educational. Unfortunately I can’t seem to find it again to link it, but the gist of it was that there would be two things wrong with using SSNs as primary keys in a SQL database:

  • You should not use externally generated data as primary keys
  • You should not use personally identifying data as primary keys

  Using SSNs as keys would violate both.

  I went looking for best practices regarding SQL primary keys and found this really interesting post and discussion on Stack Overflow:

  stackoverflow.com/…/whats-the-best-practice-for-p…

  My first thought was that people’s SSNs can and do change, and sometimes (rarely?) people may have more than one SSN. Like someone mentions in that link, human error would be another reason why you would not want to use external data and particularly SSNs as primary keys.

• ⁨Comment⁩ on ⁨[deleted]⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  Thanks, this sounds like the most accurate and precise answer to the question.

• ⁨Comment⁩ on ⁨Can the public expect to get to see Luigi Mangione's 3 page manifesto in its entirety in a reasonable timeframe?⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  This one is fake. The real one has now been published by Ken Klippenstein, and is linked in another comment on this thread.

• ⁨Comment⁩ on ⁨California’s new law forces digital stores to admit you’re just licensing content, not buying it⁩ ⁨⁨4⁩ ⁨months⁩ ago⁩:

  Even better, “buy non-transferable license”, because that’s technically what it is.

• ⁨Comment⁩ on ⁨California’s new law forces digital stores to admit you’re just licensing content, not buying it⁩ ⁨⁨4⁩ ⁨months⁩ ago⁩:

  Not trying to argue, but I don’t believe I can re-sell my copy of a game I “bought” on GOG, so in my view that’s not full ownership as most people understand it. If you’re a full, legal owner of some property, you can sell that property anywhere you like.