Where did the Lemmy name originated from? How long was the development of Lemmy?

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

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.

I would love a way to optionally post a location while choosing specificity, i.e. United Kingdom vs Newcastle etc. That way I can filter communities and posts to just those in a location I like.

I think it could lead to some really cool interactions and ways of looking for things.

A bit late on this, but when can we expect the new rewrite of Lemmy's UI? It seems like a big task.

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?

What is the best Motorhead album, and why is it Overkill?

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.

Can we have a filter for excluding memes, please? Some times I want them, some times I don't.