Old New Tool: View Your Proxy Supporters


This is technically not a new tool. However, it was based on @steemsql - which is now dead.

It is not that difficult to gather the information needed for this tool. You just need to crawl blocks from 0 to the latest, then sync with it, extracting the relevant information (account_witness_proxy) and store them in a database either relational such as sqlite, mysql or non-relational such as mongodb.

Depending on the schema, you could store entire witness proxy history, or store all proxy votes from same account, or even, store only the latest proxy votes (disregard previous votes).

The first two scenarios require filtering previous votes:

sql = """
SELECT name,proxy,time,block  
FROM proxy as P1 where
block = (
   select max(block) from
   proxy as P2
   where P2.name = P1.name
) and 
proxy = '""" + id + """'
order by time desc
"""

Any way, the tool:
https://steemyy.com/proxy/
Chinese verision: https://steemyy.com/list-of-proxy/

And API is provided as well, where it returns not only the direct proxy voters but who vote them, and who vote who vote them...

Example:
https://steemyy.com/api/steemit/proxy/?cached&id=justyy

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 8


Hello @justyy I have chosen you as a witness a few months ago, but I have never been appreciated by a witness
IMG_20200524_231508.jpg

24.05.2020 16:18
0

Thanks for staying at STEEM!

24.05.2020 16:26
0

Yes.

24.05.2020 17:03
0

You are my witness @justyy Good job..!!!

25.05.2020 02:47
0

Thank you

25.05.2020 08:43
0

给行长拍手了
!shop

25.05.2020 08:43
0

感谢,回赞。

25.05.2020 21:18
0

你好鸭,justyy!

@annepink给您叫了一份外卖!

卡姐的温暖牌爱心早餐

吃饱了吗?跟我猜拳吧! 石头,剪刀,布~

如果您对我的服务满意,请不要吝啬您的点赞~

25.05.2020 08:43
0