turtle

@turtle@lemm.ee

• ⁨Comment⁩ on ⁨Apple TV+ subscription available at a 70% discount for a limited time⁩ ⁨⁨3⁩ ⁨weeks⁩ ago⁩:

  They must be feeling the pinch of a ton of their subscribers cancelling it after they watched the last episode of Severance.

• ⁨Comment⁩ on ⁨Gen Z's safe space - Sick of Musk and Zuckerberg, Gen Zers are flocking to Tumblr⁩ ⁨⁨4⁩ ⁨weeks⁩ ago⁩:

  The WordPress company, as in the developers of WordPress itself.

• ⁨Comment⁩ on ⁨Judge calls out OpenAI’s “straw man” argument in New York Times copyright suit⁩ ⁨⁨4⁩ ⁨weeks⁩ ago⁩:

  This is almost like a real-world Chewbacca defense?

• ⁨Comment⁩ on ⁨Three original movies are being released in theaters today⁩ ⁨⁨5⁩ ⁨weeks⁩ ago⁩:

  Haha, yes, that!

• ⁨Comment⁩ on ⁨Three original movies are being released in theaters today⁩ ⁨⁨5⁩ ⁨weeks⁩ ago⁩:

  Jason Statham is like his own IP now, similar to superhero or star wars movies. Should we call it the “Jason Statham universe”?

• ⁨Comment⁩ on ⁨Firefox deletes promise to never sell personal data, asks users not to panic⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  That’s fair. But what they’ve said so far seems to strongly point at this being the reason.

• ⁨Comment⁩ on ⁨Firefox deletes promise to never sell personal data, asks users not to panic⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  Think about it. Anything you type into a browser is your intellectual property, you own the copyright to it, unless you’re copying someone else’s text. In order for Mozilla to pass what you type on to any website you’re visiting, they need to “copy” that text.

  I think this is what they’re trying to address with their legalese. It’s a pity that it has to come to this, but that’s how the legal environment is these days. They can’t afford to make expensive mistakes.

• ⁨Comment⁩ on ⁨EA has open sourced Command & Conquer: Red Alert under GPLv3⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  That’s actually kind of a brilliant concept that should serve as an example for other video game publishers then: open-source the program so that it can be maintained by the community, but require a license to use the artwork. The community could eventually recreate and even improve the artwork anyway.

• ⁨Comment⁩ on ⁨EA has open sourced Command & Conquer: Red Alert under GPLv3⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  That would be a completely legendary move if the dev hired by EA just said “fuck it, I’m open-sourcing this shit!”

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨2⁩ ⁨months⁩ 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?⁩ ⁨⁨2⁩ ⁨months⁩ 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?⁩ ⁨⁨2⁩ ⁨months⁩ ago⁩:

  Oh, I hear you!

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

  I can definitely imagine all that. Thanks!

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

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

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