• 4 Posts
  • 491 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
    ·
    17 hours 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
    ·
    2 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.



  • Also, be aware that if it is debit and not credit card, it can take quite a while for the hold to come off. This isn’t on the gas station, it’s on how quickly your bank handles them. My bank it’s around 2-3 business days, but I know some it can be up to four weeks. Granted, this is my experiences in Asia and around Europe, but wouldn’t be surprised if it’s the same in the US.

    If you think that’s the case, confirm with your bank before you using it and accidentally end up with a few hundred on your account just stuck there for a while.




  • This place, it hosts many personalities that are unable to empathise. It’s why a simple comment reminding people to tap into empathy for fellow humans, reminding people to aim energy responsibly, it ends with this behaviour instead.

    It really doesn’t matter for the cause if the behaviour is just as toxic as the opponent, though. A piece of shit is just a piece of shit, no matter how much they claim morality.

    But in this case, they’re doing exactly what their opponent wants them to do. And if there’s a lack of empathy, a lack of seeing the hypocrisy, I doubt there’s much hope for clarity on that as well.


  • Hey, I’m gonna go out there and say plenty of them are Mr Garrisons. We see the same shit in any force. If you need headcount, offer the poor enough and they’ll do it. Nit because they agree, but because shits so fucked they’re being offered silver lining and more.

    Always send your energy toward the head of the snake. Those coordinating, those leading. ICE grunts are riddled with fuckheads, but some of them are not. ICE team leaders are guaranteed fuck heads. Up and up and up, the bigger the fuck headery. Aim for the head.

    Every force in history has socially worked this way






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