Published: 24 Aug 2017 › Updated: 24 Aug 2017
Top 20 users with the highest reputation on Steemit.com - Data from the blockchain using DBeaver
I really-really wanted to see some numbers out of the Steem blockchain, and I found DBeaver, which is an open source database tool for data analysts and can connect to DBSteem.
I have found a Chinese tutorial with English translation about how to install, connect to DBSteem and set it up.
It took me 5 minutes or less.
The main part for SQL connection:
Host: sql.steemsql.com
Database/Schema: DBSteem
User name: steemit
Password: steemit
I wanted to see the top 20 users with the highest rep, their posts number and SBD balances.
I put this in
select top 20 name, cast(log10(reputation)*9 - 56 as decimal(4,2)) as reputation, post_count, SBD_balance
from Accounts
where reputation>0
order by reputation desc
And I got this! I am so happy, but still I need to go much deeper, but for me it is fun now!
Then I set up to 2000 users, so it is bigger fun.
I am learning by doing, if you see any mistake or have recommendation, drop me a line, please! Thanks
Leave Top 20 users with the highest reputation on Steemit.com - Data from the blockchain using DBeaver to:
Read more #data posts
Best Posts From Z
We have not curated any of coinkingz's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.
More Posts From Z
- Dear Followers. Follow me at @zoltanbristol
- I've lost 470 followers and $800+, follow me at @zoltanbristol
- To write or not to write...
- How to loose $660 on Steemit?
- I lost my account. Follow me at @zoltanbristol
- Am I hacked? I vote automatically and my voting power goes down quickly! Please help
- Street art Duckface. Best for today
- Do you know who started following you on Steemit? Easy tool to check
- Top 20 users with the highest reputation on Steemit.com - Data from the blockchain using DBeaver
- Introducing Bristol - Stokes Croft, the creative district