this looks removeding great!

Ok fair enough. But (outside of the context) defederating/banning certain communities because they don’t have the same beliefs as you can lead to a fully opinionated/based fediverse and should be prevented imo. Everybody should be able to express their opinions no matter what. I don’t want lemmy to change into some kind off mass media like everything else rn. If a post isn’t showing a good/kind, people respecting vibe, it will be downvoted and thus not shown to anybody. And later if lemmy creates an algorithm of some kind, these posts can be ghosted for certain individuals. But i don’t think they should be completely removed and banned from the connected fediverse as this platform is one of the only ways to express ourselves online at this point. I hope i could get my point across

Is there any limitations with the database (postgres)?. I know postgres is one of the best (maybe even best) monolith database (running on one node) at the moment, but will the space be enough? With this in mind, has there been any consideration of migrating to a distributed database like ScyllaDB or CassanraDB to alleviate potential space constraints? On the other hand, if Lemmy doesn’t intend to store data for long periods, maybe the capacity of Postgres would suffice. Any thoughts or plans on this? I appreciate your insights on this matter.

The thing that came to my mind is to have all torrent links in some kind of blockchain, where new torrent links can be added all the time and if someone wants to help the community they can just download all the torrent links from the blockchain and help seeding the torrents. These can be images, videos, audios or whatever else. The problem hereby is it can get really big really fast. This could be prevented by adding size limits for specific file types and also removing torrents from the blockchain, which werent used by a user for a long time. Effectively we would have to add a counter for visits in the last 6months and also the last viewed date from a user for each torrent. That way old, not frequentely accessed data would be deleted and prevent the size to get too big.
This general approach would prevent data loss but also help decentralize data. Of course this is just a concept which just came to my mind but it should be possible to implement i think

Wasnt free speech all about being able to express your opinion without getting banned?