Nothing4You

based on the creation date advertised by the instance, lemmy.ml exists since 2019-04-20. lemmy.world exists since 2023-06-01.

Then I generated sql statements to remove duplicate posts that had higher ids than the other posts theyre a duplicate of

i assume this was done after updating the other tables referencing this table, such as comments, votes, saved posts, as previously discussed on matrix?

while it may be omitted here for simplicity, it can be dangerous to not mention that for others that might find this in the future if they experience index corruptions on their own if they don't fix all references, as that would result in data loss.

you can find your user info in the /api/v3/site response. the /api/v3/user endpoint requires a name or person id.

i recommend checking out https://join-lemmy.org/api/classes/LemmyHttp.html

you can only set a community to only allow local users, not prevent users from interacting with remote communities.

you'd have to either disable federation or set up a script to automatically remove all remote communities, but that also won't be a per user thing, just a per instance thing.

You basically can't if your instance was set up before 0.19.4, as there won't be any association between users and uploads for older uploads. You also can't do this without breaking thumbnails everywhere unfortunately.

The latest Lemmy version has a fix where thumbnails now are actually stored at a reasonable resolution for thumbnails, but old thumbnails may be quite large, and this does not retroactively shrink older thumbnails.

It's possible to pull image aliases from the DB and ignore them when iterating over aliases within pict-rs, but you these will only be manual uploads, not automatic uploads like generated thumbnails. For posts by local users, deleting thumbnails will also end up breaking them for 0.19.5+ instances, as they should reuse the original thumbnail url.

while this is generally what most people talk about when speaking of defederation, admins can also decide to remove communities locally without blocking the entire instance.

you might find some inspiration from https://breezewiki.com/ - either its codebase directly or using it as an intermediary while scraping

@fmstrat@lemmy.nowsci.com there's also rss feeds for communities

ugh, i didn't notice they're even hiding domains of remote communities for "simplicity" in most cases. that seems so much more dishonest tbh.

this isn't entirely true, they do have some comments on lemmy as well, here are some examples:

• https://programming.dev/u/vinaya@api.clubsall.com
• https://programming.dev/u/chester22@api.clubsall.com
• https://programming.dev/u/impresario@api.clubsall.com
• https://programming.dev/u/luckymann@api.clubsall.com
• https://sh.itjust.works/u/BlazeFromLemmy@api.clubsall.com

it seems to be primarily about their communities not federating though i guess?

and either nobody from there posted a post to a lemmy community yet or maybe it doesn't federate posts currently?

lemmy.ml doesn't use cloudflare, that's strange.

i've also never had issues with this when looking at instances that do use cloudflare.

pretty much, yeah. lemmy has a persistent federation queue instead of fire and forget requests when activities get generated. this means activities can be retried if they fail. this allows for (theoretically) lossless federation even if an instance is down for maintenance or other reasons. if mbin has a similar system maybe they could expose that as well, but unless the system is fairly similar in the way it represents this data it will be challenging to integrate it in a view like this without having to create dedicated mbin dashboard.