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

coinkingz(56)
Published in
#data
Words
178
Reading
1 min
Listen
Play
9y

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

Top 20 users with the highest reputation on Steemit.com - Data from... | Ecency