Follow

If anybody is curious, a quick query to see who your subscribers are on PeerTube (assuming that you have database access on your instance):

select (select "preferredUsername" from actor where id = "actorFollow"."actorId"), (select "preferredUsername" from actor where id = "actorFollow"."targetActorId"), (select url from actor where id = "actorFollow"."actorId") from "actorFollow";

There's probably a better query for that, but this is:

1. Who follows
2. What's followed
3. Follower url

· · Web · 0 · 0 · 0
Sign in to participate in the conversation
Typica Social

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!