Z avatar

Top 20 users with the highest reputation on Steemit.com - Data from the blockchain using DBeaver

coinkingz

Published: 24 Aug 2017 › Updated: 24 Aug 2017Top 20 users with the highest reputation on Steemit.com - Data from the blockchain using DBeaver

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.

dbeaver.jpg

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!

top22.jpg

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:

Written by

Street art, surf, social media, popculture and utopias

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