Edit: obligatory explanation (thanks mods for squaring me away)…

What you see via the UI isn’t “all that exists”. Unlike Reddit, where everything is a black box, there are a lot more eyeballs who can see “under the hood”. Any instance admin, proper or rogue, gets a ton of information that users won’t normally see. The attached example demonstrates that while users will only see upvote/downvote tallies, admins can see who actually performed those actions.

Edit: To clarify, not just YOUR instance admin gets this info. This is ANY instance admin across the Fediverse.

  • AngryHumanoid@reddthat.com
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    I write my joins the same way (instead of JOIN tablename on one row and ON columnnames on the next row) and my coworkers think I’m weird. IT’S EASIER TO READ THIS WAY, DAMMIT.

    • Demiurge@kbin.social
      link
      fedilink
      arrow-up
      2
      ·
      1 year ago

      Who the hell does the joins like that? SQL already has a fuck ton of lines and they want to separate the statements into more lines? wild.

      I also always use alias instead of the full table name.