SteemSQL - Database updated and ready for Communities
5 years ago by arcange (73)
$2.75
- Past Payouts $2.75
- - Author $1.41
- - Curators $1.33
158 votes
- + bobbylee: $0.619 (50%)
- + arcange: $0.446 (100%)
- + ripperone: $0.323 (24%)
- + mangos: $0.212 (22%)
- + quochuy: $0.147 (100%)
- + techslut: $0.093 (100%)
- + scorer: $0.077 (100%)
- + teammo: $0.061 (100%)
- + apshamilton: $0.057 (100%)
- + abh12345: $0.049 (15%)
- + dalz: $0.048 (100%)
- + bewithbreath: $0.043 (100%)
- + jpbliberty: $0.036 (25%)
- + vaansteam: $0.036 (30%)
- + hamismsf: $0.034 (25%)
- + tobetada: $0.033 (25%)
- + inertia: $0.031 (100%)
- + ace108: $0.028 (4%)
- + alexanderfluke: $0.028 (25%)
- + steemprotect: $0.027 (100%)
- … and 138 more
Hey man ... great job ... will test it out soon :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Oh damn. Thanks for the update #cats is just what my @busybody needs.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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. 😎
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Ah, thanks. I was looking through the views and didn't see the communities ones yesterday.
Good to experiment bit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit