I finally found some time recently to look at , the database service provided by
that converts the Steem Blockchain into a usable Database structure. Let the data manipulation commence!
Since I posted recently of my idea for what I called a generosity rank algorithm for Steemit to help improve post quality and reward pool usage, I decided to start coding a proof of concept using . After a couple of days
announced that the service would no longer be free to use as it requires considerable hardware and time to keep running - so I have become one of his first customers, playing 10SBD for one month's access to the data - so I'd best make good use of it.
So far I have got about halfway through coding the vote rank index algorithm (no longer named generosity rank algorithm) and I aim to have a usable page online within the next week - I am very busy at the moment with other work.
Observations of note so far:
- Indexing the entire blockchain will take days of processing, so initially I will just use data from the last 7 days of paid out posts to calculate the index values and ranks for each profile.
- I need to take account bot profiles since they are currently topping the rank table (utopian in particular). If we compare everyone's vote behaviour to utopian or another bot, we will have skewed results. I might make an option to either include or exclude bots on the finished rank checker page.
- The general concept of the algorithm appears to work ok. I will adjust it further once I am able to complete the first full indexing. Even with a greatly reduced range of data to process, the processing time is still quite long.
- I can see interesting accounts being highlighted by the code, at least one of which is actively advertising that they are 'raping the rewards pool' for fun.
- Since I am calculating the value of historic vote payouts, I am able to see some stats that I haven't seen on other sites - it's pretty interesting. Maybe I will make some graphs too just for a source of additional statistics.
More to come soon!
Wishing you well,
Ura Soul

View My Witness Application Here