You are viewing a single comment's thread from:
RE: Market Share of the Steem Blockchain by Application: May 2018 Analysis
Nicely complied 😁 That 'group by' statement looks fun!
Steempress has grown a lot this past month, look out for that one next time. Might have to label it 'spampress' 🙈
Ha! The group statement just takes out the version numbers from the apps. So busy/2.4.0 and busy/2.4.1 are both just treated as busy. There's probably a cleaner / quicker way to do it with the new steemsql json_metadata search functionality. One to work on for next time.
Steempress does stand out doesn't it. 300 authors and 40,000 posts. I'm sure steemcleaners will pick up the worst offenders, as and when necessary.
Lots of interesting things in development further down the table though, some of which I'd never heard of. I think we're slowly moving towards a wider network of separate sites and apps all posting to the same blockchain. Probably something that will increase when SMTs arrive. It's good for decentralisation and I think there are still plenty of opportunities for developers and entrepreneurs to get involved and get their projects on board. The second half of 2018 could be mighty interesting!