• 0 Posts
  • 238 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.


  • saltesc@lemmy.worldtoxkcd@lemmy.worldxkcd #3169: EPIRBs
    link
    fedilink
    English
    arrow-up
    4
    ·
    8 days ago

    Registration Status: Registered.
    Beacon Type: EPIRB.
    406MHz GPS (Cat. 2) 66-channel. Beacon Status: Operational.
    Battery Expiry Date: 01/10/2028.

    It’s UIN—which I obv won’t give lol— doesn’t hold an MMSI. The main reason being EPIRBs aren’t just for marine craft.


  • saltesc@lemmy.worldtoxkcd@lemmy.worldxkcd #3169: EPIRBs
    link
    fedilink
    English
    arrow-up
    20
    ·
    9 days ago

    I have a handheld one—to float with me in a liferaft, etc—and it gets registered to a vessel or vehicle. Whenever I want to use it on something different, contact the federal government, advise of the new vessel ID or vehicle registration, and it’s now associated with the new one.

    I don’t think it matters much since it is a beacon after all, but I think it helps in searching. Also, a lot of other details are registered along with it so they know who to send the tens of thousands in fines to if I somehow bypass all three “Are you really sure?” switches and fire the thing off inappropriately.


  • 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.










  • 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.







  • Friend’s colleague needed Excel to, “return the month where the majority of days in the week fall into”. Had Copilot do it and sent it to my friend, apparently impressed by making such a robust looking formula.

    The formula:

    My friend’s solution a minute later:

    I can see it could be slimmed even less, but I assume the table is large so LET is doing performance stuff.