• 1 Post
  • 315 Comments
Joined 2 years ago
cake
Cake day: July 1st, 2023

help-circle

  • SQL enjoyer?

    Every time I use it I feels like I’m going back to the 90s. No variables, no functions; Oh but you can do a CTE or subquery…👍

    UNION ALL, UNION ALL, UNION ALL… “There’s got to be a better way, surely…”

    looks up better way

    “Oh, what the fuck?!.. Nope, this will just be quicker…” UNION ALL, UNION ALL, UNION ALL…

    Join in a table sharing column names… Everything breaks. You gotta put the new prefixes in front of all the headers you called in now. In every select, in every where, etc… Which is weird because that kinda works like a variable and it’s fine…

    “When you see this little piece of text, it means all this, got it?”

    “Okay. Yep. Easy.”

    “So why can’t you do that with expressions?”

    SQL SCREAMS MANICALLY

    “Okay, okay, okay!.. Jesus…”

    And then you try put a MAX in a where and it won’t let you because you gotta pull all the maxes out in their own query, make a table, join them in, and use them like a filter…

    I hate it. It has speed, when you can finally run the script, but everything up to that is so…ugh.




  • The article is only referring to per device keys and passkeys that lock them on that device. In other words, someone would need to be able to get your device’s key, decrypt it or brute your passkey, spoof or steal your device somehow, and send the key under it’s identity. I’m sorry, but I don’t think the few people that could do that would be wasting their time to do it to little old you. For most people, their insignificance is the best security they have.




  • That’s the thing. America’s majority “progressive” cohort are still a little right of centre by the standard of most other developed societies. But for many conservatives, I think “progressive” is synonymous with “the far-left” in their minds, when really it’s more just playing catch up with the world or trying to restore intended concepts of the US Constitution.

    Health, income protection, economic regulation, appropriately funded education, crisis/disaster/wellbeing support, etc. These are your “basics” by default. Common rights and protections for individuals. But if your country doesn’t have them, it would be seen as progress attaining them in the same way roads, voting, and sanitation were progress. It’s be foolish to stop evolving a society under the idea that there’s no benefit to new and proven advancements in society and culture. Your average American progressive just wants to roll that update in and get some nice new features and quality of living. When a conservative says “no!” they’re not realising they’re saying “yes” to continuing in their modern dark ages.










  • I like my PC being my PC. The more it does things I don’t ask of it or tell it to do, the more I will seek alternatives.

    One of the most frustrating parts of MS products these days is that you’re just along for the ride. And unlike Apple which is just the same, MS has far less intuitive behaviour or method. I would say their products are for beginners or those not tech literate, but the failure rate and amount of complex troubleshooting required for MS products and environments are easily the most challenging and frequent. It does not help that Windows Update constantly introduces new issues to the OS and other software while undoing any previous workarounds.

    That company doesn’t get to touch my stuff anymore. It’s like trusting your car to a four year old.



  • Proving even on Lemmy, you and me are extremly prone to propaganda.

    Uuuuh… This place is a breeding ground of heavily biased propaganda. Just look at your feed, it’s all news articles reinforcing a side of things. It’s got its fair share of users that don’t look at things from a broad perspective and most get mad when they perceive their opinion is being challenged, even when it’s not. That’s why it’s riddled with posts that aren’t for interest; they’re rooted in agenda that is to either push narrative or reinforce ego.

    And if your filter lists aren’t full of users, communities, and instances, it’s very plausible your mind my be one that’s easily duped, because the shits got to be one of the most obvious places on the internet to spot it. Part of the Lemmy experience is maintaining and customising the feed.