We just launched Lemmy fully managed hosting service and we can see indeed an important interest from all over the world :)

https://elest.io/open-source/lemmy

I think we really need to address the scaling issue, one option could be to use clichhouse instead of postgres

Issue is cpu and memory usage, it's very intensive...

We could add an openapi option, server admin will be able to provide an API key and we could use that for auto moderation, it's fast and cheap enough ($20 per 10 M characters)