STATS ... i would want to know.
This is something that can be easily achieved using HiveSQL. I already provide some in my daily stats (section 7)
Language classification of a post...
HiveSQL already provides such information (and more) for ages. Here the announcement post I made back 2016.
Feel free to contact me if you want to have a talk about that.
I'm pretty sure you've been on the developer meetings where they have talked about languages. Are you not a fan of some of those solutions mentioned there?
Do you have an API that would lead to me being in a topic page or a feed for a badge or maybe even community and then ask to see all Italian or Tagalog posts and instead of accessing 2000 posts via the api to simply filter and find only 1-2 you can instead query an API that would immediately and quickly populate the list and choose from the typical sorting mechanisms like the trenging algorithm or chronological?
Also i was thinking that having a dozen nodes providing hivemind API is helpful for decentralization and for ramping up to having lots more users...so it seems to me it would be nice to be in there.
Yes, I was part of the language discussion at the development meeting. That being said, I don't think a "solution" for hivemind has been proposed or planned.
I do not provide an API on top of HiveSQL because this will add an unnecessary extra layer. Add to that that such an API would be limited to what I think is OK for me, but not necessarily tailored to someone else's needs. This is already the problem you are having with Hivemind where you have to wait for someone to provide you with the API you want.
Any dev can create its own API or directly send a request that fits its wishes to HiveSQL. The one you are mentioning for Italian would take a few minutes to create, including filtering and sorting. I can assist you with this task.
Regarding decentralization, HiveSQL is of course not comparable to hivemind, but it no longer has to prove its reliability.
Nothing prevents you from creating a thin layer that allows you to switch from one solution to another if ever hivemind ever had to implement the features you need.
Maybe we'll have to look into hivesql for some community stats and see what's possible.
I'm still very interested in focusing on how many Content Posts a community has seems like it usually focuses on content posts + comments... the thing about that is it doesn't really say much about the community itself. Because we know how hive works. Someone that has a lot of subscribers could happen to post in your community and all of their followers comment on that post and not a single one of them is part of the community or could care less about the community or even recognizes they posted in a community but it came up in their feed. Then you have 100 comments and now your community looks like it has 100 activity with one single actual content post? To someone looking for a community and they come in and see 1 post in the community they see a ghost town then they go somewhere else with 20 content posts they see life even if they all just had 4 comments... that's an alive community and the stats do not reflect this in the slightest.
My stats are about posts (what you call "content"), not comments.