i hate it.

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