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.

Any thoughts on the "federated community" discussion? I find both positions to have merit, but I think I'm leaning towards community aggregation as an option.

https://github.com/LemmyNet/lemmy/issues/3033

Do you plan a mod queue?

Where either in active mode hides the post and only after approval reveals itself or passive just have an queue for mods to see all the posts to double check?

Can we have an option to enable opening a new tab on click? I hate when I forget to middle click or control left click, and losing my place of scroll.

Any plans for aggregated total of upvote/downvote karma for each user?

Is there a use case for a user creating their own Lenny instance for their own use?