• 9 Posts
  • 17 Comments
Joined 1 year ago
cake
Cake day: June 6th, 2023

help-circle








  • Welcome and I hope you enjoy interacting in this space!

    One thing to note is that communities across the instances (lemmy.ml being an instance) will have varying content and vibe, and may differ from what you might expect of an instance. So if you’re selective with the communities you subscribe to and typically only scroll through your Subscribed front page, filtering out lemmy.ml might not be necessary.














  • Assuming you’re viewing on mobile, at the top of the page, there should be a Sidebar button. Click that and it will expand the sidebar. There should now be a Subscribe button for you to subscribe to the community.

    Note that the URL should look something like <local instance url>/c/<remote channel>@<remote instance hostname>. For example, my local instance is Beehaw too and I’m trying to view AskLemmy on lemmy.ml, so it should be something like beehaw.org/c/asklemmy@lemmy.ml



  • ds12@beehaw.orgtoLemmy@lemmy.mlRemoving accounts
    link
    fedilink
    English
    arrow-up
    5
    arrow-down
    1
    ·
    1 year ago

    This probably needs verification, so run at your own risk!

    The SQL statement to delete would be: DELETE from person where name = '...'

    person is the table of users.

    name = '...' is the condition for the row that is to be deleted.

    You can also modify the condition to, for example, delete a user using the id instead of their name (username).

    Here’s a link to the “schema” of the person table as generated by the backend code.