i hate it.

  • 2 Posts
  • 79 Comments
Joined 1 year ago
cake
Cake day: June 30th, 2023

help-circle


















  • If you run a server…

    #!/bin/sh
    INSTANCE=myinstance.com
    psql -U lemmy -c "SELECT (person.name || '@' || instance.domain) AS user, 
    ('https://' || instance.domain || '/u/' || person.name) AS their_instance_url,
    ('https://${INSTANCE}/u/' || person.name || '@' || instance.domain) AS url,
    comment_like.score
    FROM comment_like
    JOIN person ON comment_like.person_id = person.id
    JOIN instance ON person.instance_id = instance.id WHERE comment_id = $1;"
    

    Edit: lol@ the downvotes. Do people think lemmy operates on the principles of magic? Sorry my SQL offends you.




  • amigan@lemmy.dynatron.metoNo Stupid Questions@lemmy.world*Permanently Deleted*
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    1
    ·
    edit-2
    7 months ago

    I fail to see your point. Of course it is not merely “encrypting your shit.” But a constructed language is more dangerous than using existing crypto. It is subject to frequency analysis and many other analyses. And aside from the point of “if you can memorize it’s flawed,” you might as well just use a one time pad at that point. Generally, if you are not a cryptographer and you design a cipher, that cipher will be flawed. The human element of being suspicious of a surveillance state is certainly valid, and you are right, it is not something I generally worry about on a daily basis, mostly because I am not presently engaged in any such high risk activities. I am saying nothing about this not changing and never becoming something to worry about, but you bet your ass I will be employing cryptography designed by experts if that day comes.

    And anyway, all my webservers are https, I am an avid user of gpg, and I’ve been working in “cybersecurity” for over a decade now, so I like to think my opsec isn’t total garbage. After all the Snowden stuff came out, it just reinforced my existing practices and birthed new ones. Also, wireguard is the shit.