Upvote/Flag Tools Re-worked


Previously, the following tools (upvote and flags) are based on @steemsql

And Chinese versions:

I decided to abandon @steemsql and thus spent this weekend reworking these tools. The upvotes/flags data are slow to search at realtime but we can always process the previous blocks and store the processed data in the (centralised) database similar to what @steemsql does.

It is roughly 10,000,000 blocks per year on Steem Blockchain (3 second per block), i have processed the last 3,000,000 (around 3 months) and modified the underneath APIs uses in all above tools. The database size is around 11G for the latest 3 month's data.

Also, charting has been added to 3 of them. For example:

image.png


I hope this helps!

Steem On!~

If you like my work, please consider voting for me, thanks!
https://steemit.com/~witnesses type in justyy and click VOTE



Alternatively, you could proxy to me if you are too lazy to vote!

Also: you can vote me at the tool I made: https://steemyy.com/witness-voting/?witness=justyy

Visit me at: https://steemyy.com


Comments 16


The witnesses are well aware of what happened to @DarthKnight who accidentally powered down to bittrix. Despite the witnesses pledges not to freeze peoples accounts, and their pledges to protect private property. He tried to correct the error, but the witnesses, including Justyy, froze his account so he could not change the powerdown to bittrex.

Remember, with witnesses like Justyy, you just have chicom cocksucking thieves and liars at the helm. They cannot be trusted.

https://steemd.com/@darthknight

I am not going to shut up. How many hundred of thousands or even millions of dollars did the people who trusting in you lose because you make terrible real life decisions as you sell everyone out to the Chinese communist party.

People should know, never to trust justty. He can downvote all he want with the stolen steem delegation, but it doesn't erase reality. All those who have trusted justyy need to leave him behind. He are a poison, a disease, a central rot of steem chain and anyone that is loyal to him.

17.05.2020 23:05
0

Thank you for the work you do, I just delegated 500 SP and voted for you as a witnesses!!

17.05.2020 23:24
0

Thank you very much!

18.05.2020 15:36
0

Thank you again looking to delegate more in the future have a good day!👍

18.05.2020 20:56
0

You are aware that he is about to steal 5 million dollars out of peoples wallets. Stop enabling this criminal.

20.05.2020 09:10
0

I also just Delegated 500SP and voted for you as a Witnesses!

17.05.2020 23:30
0

Thank you very much!

18.05.2020 15:35
0

You are very welcome! I plan to do more soon! Take care!

19.05.2020 02:40
0

You are aware that he is about to steal 5 million dollars out of peoples wallets. Stop enabling this criminal.

20.05.2020 09:09
0

好久没回来啪啪啪了

给行长拍拍手

18.05.2020 04:52
0

感谢,回赞。

18.05.2020 15:36
0

The search function does not work for me. When I search "flag tools" your article does not show up. In fact, nothing shows up. Is this your experience as well? Will it be fixed?

19.05.2020 03:12
0

Thanks. I will let SteemInc know

19.05.2020 13:55
0

A couple days ago steemit was down for over 8 hours with no prior notice. Can steemit set up a systems status communication mechanism?

19.05.2020 14:45
0

You misspelled Stinc, retard

20.05.2020 02:48
0