turtle

@turtle@lemm.ee

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨12⁩ ⁨hours⁩ 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⁩ ⁨day⁩ 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 ⁨Amazon’s killing a feature that let you download and backup Kindle books⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  Awesome, thank you!

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

  Oh, I hear you!

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

  I can definitely imagine all that. Thanks!

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨1⁩ ⁨day⁩ 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⁩ ⁨day⁩ 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⁩ ⁨day⁩ 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 ⁨Amazon’s killing a feature that let you download and backup Kindle books⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  Ugh, thanks for the warning. Time for me to download and de-drm all my old kindle books and never again buy anymore.

• ⁨Comment⁩ on ⁨Be the change you want to see in Lemmy⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  Ah, yes, that makes sense now! If it is an automatic, random server selection, then I also agree that it should be only generic, non-controversial instances that are selected.

• ⁨Comment⁩ on ⁨Be the change you want to see in Lemmy⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  As long as it’s clearly labeled as something like “a communist instance”, why not? Some potential Lemmy users would probably feel right at home. It doesn’t even have to be a controversial label, just a factual description that the Lemmygrad people would agree with.

• ⁨Comment⁩ on ⁨Be the change you want to see in Lemmy⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  create some set of rules for “default instances” - every instance that wants to be in the list must follow them and will be periodically checked

  I don’t have any particular rules in mind, but some examples might include active moderation team, obviously registrations being open and if you really want to make it easy, either no application question or having it automatically approved by an automod of some kind
  

  The Mastodon Server Covenant is pretty much what you describe here, and could be used as a starting point: joinmastodon.org/covenant

• ⁨Comment⁩ on ⁨Be the change you want to see in Lemmy⁩ ⁨⁨1⁩ ⁨day⁩ ago⁩:

  It’s so much easier to comment and get replies here.

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨1⁩ ⁨day⁩ 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 ⁨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.

• ⁨Comment⁩ on ⁨NIST proposes barring some of the most nonsensical password rules⁩ ⁨⁨4⁩ ⁨months⁩ ago⁩:

  It’s crazy that they didn’t include all the “should” items in that list. If you read the entire section, there’s a critical element that’s missing in the list, which is that new passwords should be checked against blocklists. Otherwise, if you combine 1, 5, and 6, you end up with people using “password” as their password, and keeping that forever. Really, really poor organization on their part. I’m already fighting this at work.

• ⁨Comment⁩ on ⁨Recommend a KVM or Switch⁩ ⁨⁨4⁩ ⁨months⁩ ago⁩:

  I don’t believe that the USB-C ports can take video input, so you would most likely need to use either and HDMI to DP or USB-C to DP adapter.

• ⁨Comment⁩ on ⁨Recommend a KVM or Switch⁩ ⁨⁨4⁩ ⁨months⁩ ago⁩:

  I picked up one of these ugreen displayport KVMs a couple months ago and so far have been happy with it:

  www.amazon.com/…/B0CFFFHFJT

  The only issue I have had is that if I’m switched to computer B and computer A goes to sleep, I cannot wake it up through the switch. This was not a deal breaker for me because I have easy access to the power button of both computers. I wonder if this issue may be resolved by powering the switch with a USB-C power plug, since it otherwise requires USB power from both computer connections.