SteemSQL - Database updated and ready for Communities
4 years ago in SteemSQL by arcange (73)admin
$2.75
- Past Payouts $2.75, 0.00 TRX
- - Author $1.41, 0.00 TRX
- - Curators $1.33, 0.00 TRX
Hey man ... great job ... will test it out soon :)
I appreciate your great work in service of the Steem community. I am not a fan of the current labels for communities. Hive-nnnn doesn't communicate what the community is all about, and it's one of the reasons I have not participated in communities heretofore.
Are you aware of any way to translate hive-nnnn to 'cats'? I think that's what you meant in the final lines of your post above, at least that's what I hoped you meant.
I think that would really help communities to be useful.
Thanks!
Oh damn. Thanks for the update #cats is just what my @busybody needs.
I've played with this a bit and start to wonder..
Is there a mapping of the name to the community?
And won't that be better to map the category to the mapping that have a separate tags table?
Good for 1st question.
For 2nd question, let me see if an example will help make sense.
So far, the community ends up in category with a hive.... name (I'm just guessing from the pattern). So, with a category name like "hive-146513" which maps to the SteemSQL community, I can join the comments table on category that starts with "hive%" to the mapping table to get the community name to get a more meaning information rather than join the Tags table which result in the comments records being displayed multiple.
With the join the tags table, so happen it's displaying multiple records. So, to avoid that, while I joined to tags to search the tag, I don't display the tag and do a DISTINCT on the rest of the select columns.
Hope that helps or not confuse things further. 😎
Ah, thanks. I was looking through the views and didn't see the communities ones yesterday.
Good to experiment bit
Works great!