is there any way of querying just the interactions of an account in the fediverse? "show me all the messages where they have liked mine or I have liked their and all the messages that either I am tagged in their message or they are tagged in mine"

and if there isn't already such a tool can you imagine how one might go about that? I guess you would need to pull in all their posts and all your posts thru an api, then run it thru grep or something and then spit out all the uris

Follow

@liaizon I'm pretty new to the feddi, but if you can access your instances database I have some queries for you!

```
select *
from statuses
left join accounts a on statuses.account_id = a.id
where text ilike '%wants.coffee/@tim%'
and a.username = 'georift'
and a.domain = 'qoto.org';
```

· · Web · 1 · 0 · 0

@liaizon Ok so I guess code formatting isn't something I can do here.

This query will find any times where the user @georift has mentioned @tim

Formatting is a little weird, the link above should be replace with https:// etc..

Let me know if this is a step in the right direction I can write up the other cases you asked for.

@tim @georift I am not self hosting, my instance is on MastoHost, so not sure how to get access to the instance database for this. Maybe through an API call of some type

Sign in to participate in the conversation
☕ wanted

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