[SteemRank] Remove SQL dependencies from the bots rating, add optimization and error messages

Recently I updated SteemRank and added a rating of voting bots which is sorted by steem power. I added it because sometimes you want to just get info about the biggest bots, also this rating can provide some interesting common data about the market of bots and their distribution.

Details

But initially, the project was very unoptimized, did use SteemSQL Wrapper API, and had ugly SQL queries because I was focused on results and creating MVP (or if want — proof of concept), also I did not work with steem-js before. But today I updated the code, removed all SteemSQL Wrapper dependencies, and now the rating of bots fully use steem-js.

It is not only about refactoring, it is also about optimization and reliability — steem-js returns data much faster than SteemSQL Wrapper, it cannot have outdated data as SteemSQL, and it cannot have server faults as SteemSQL Wrapper. So now if you have bad internet than you most likely can feel the difference.

Also, initially, SteemRank did not have any possibilities to display error messages if something goes wrong. But I fixed it and now you will know if SteemRank does not get data.

SteemRank

If you do not know what is SteemRank — it is a rating of authors, categories, and bots. The main idea is an analysis of the best parts of Steemit. The main part of the project (ratings of authors and categories) was developed with SteemSQL Wrapper API. If you want more details about SteemRank then you can read an introduction post about the project.

Commit

---

Posted on Utopian.io - Rewarding Open Source Contributors

---