• 1 Post
  • 319 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.