Lemmy Helper - for server operators

59 readers
1 users here now

For Lemmy server operators and other people running an instance. Webapp and CLI for direct interface to the PostgreSQL database to query for common issues. CLI can help test your server performance and stability.

founded 2 years ago
MODERATORS
RoundSparrow@lemmy.ml
listing: all - local
1
1
Lemmy.ml unstable for lemmy-helper discussion, opened backup Discussions on GitHub project (github.com)
submitted 2 years ago by RoundSparrow@lemmy.ml to c/lemmy_helper@lemmy.ml
0 comments fedilink
 
 

Drastic scaling performance times call for drastic solutions.

2
1
GitHub - RocketDerp/lemmy_helper: Lemmy admin helper webapp for server operators (SvelteKit webapp to work with PostgreSQL database) (github.com)
submitted 2 years ago by RoundSparrow@lemmy.ml to c/lemmy_helper@lemmy.ml
0 comments fedilink
3
1
Direct Link: Some useful SQL queries for instance admins - Lemmy (lemmy.ml)
submitted 2 years ago by RoundSparrow@lemmy.ml to c/lemmy_helper@lemmy.ml
0 comments fedilink
4
1
lemmy-helper command-line interface can now grab all the communities available on a remote Instance Lemmy server and trigger a search + discovery for your local server! (lemmy.ml)
submitted 2 years ago* (last edited 2 years ago) by RoundSparrow@lemmy.ml to c/lemmy_helper@lemmy.ml
0 comments fedilink
 
 

Basic steps:

  1. login to your local server (example.com) and get a session jwt
  2. node lemmyhelper_commandline.js communitiestickle --jwt blahbalblahtoken --server0 https://sh.itjust.works/ --server1 https:/example.com/

I suggest avoiding Lemmy.ml as a source server, it is extremely overloaded for weeks.

Regarding step 1, you can get the jwt from your web browser, the server logs of your instance (when you hit it from a web browser), or using lemmy-helper: node lemmyhelper_commandline.js testlogin --help

Code is a real mess, but some cool abilities are coming together.

5
1
Not my words: but the kind of concern that had me rush and throw together lemmy_helper as fast as possible, needing to have even the most fundamental way to look into activity (lemmy.ml)
submitted 2 years ago* (last edited 2 years ago) by RoundSparrow@lemmy.ml to c/lemmy_helper@lemmy.ml
0 comments fedilink
 
 

From this posting: https://lemmy.ml/post/1492804