SteemWorld Update / New Tool Planned / Downloadable Steem Accounts DB

https://cdn.steemitimages.com/DQmXAevND4Wcy89BfHkdzDXTiUaCEnCJL55hCuW9Wh4Rzt9/sw-logo.png
https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png

I'm in the process of adding a new tool to SteemWorld that will give us an overview of all Steem accounts with many different filtering and sorting capabilities.

The tool will offer predefined sets of data like:

  • top/flop accounts by vesting shares (SP)
  • top/flop accounts by STEEM/SBD balance
  • top/flop accounts by reputation
  • top/flop accounts by earned author/curation rewards
  • biggest active Powerdowns
  • newest/oldest Steem accounts
  • and more...

It will also be possible to search for specific criteria. For example, one can search for accounts:

  • where recovery_account = abc
  • where proxy = abc
  • where mined = 1
  • and more...

In regards to keeping the database updated in real-time I'm still in the planning stage and maybe I will build an own plugin for steemd for this. As I already parse each block for other tools on SteemWorld, I might implement it in the existing parsing routines. I will see what's the best solution in my case and keep you updated.

For now I created a test (SQLite) db that contains all the data I need (updated last night) with simple indices (no multi column indices for now, just one for each column in the table). If you are a developer or statistics guy and you want to play around with the data, you can download the (xz compressed) database here:

https://steemworld.org/dl/steem_accounts.sqlite3.xz ( 96.6 MB compressed / 586.0 MB uncompressed )


The accounts table currently contains the following columns:

  • id
  • name
  • recovery_account
  • proxy
  • created
  • last_account_recovery
  • last_account_update
  • last_owner_update
  • last_post
  • last_root_post
  • last_vote_time
  • next_vesting_withdrawal
  • balance
  • sbd_balance
  • reward_steem_balance
  • reward_sbd_balance
  • reward_vesting_balance
  • reward_vesting_steem
  • savings_balance
  • savings_sbd_balance
  • vesting_shares
  • delegated_vesting_shares
  • received_vesting_shares
  • to_withdraw
  • withdrawn
  • vesting_withdraw_rate
  • curation_rewards
  • posting_rewards
  • reputation
  • pending_claimed_accounts
  • post_count
  • savings_withdraw_requests
  • withdraw_routes
  • can_vote
  • mined

If you are on Linux, you can just install 'DB Browser for SQLite' (open source) and jump directly into the db explorer simply by double-clicking the file (after decompressing it from steem_accounts.sqlite3.xz to steem_accounts.sqlite3 of course).

As @amico stated, the SQLite DB Browser is also available for Windows and MacOS ;)

Have fun and Steem on!

https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png

If you like what I do and you want me to be your Steem witness, please vote for @steemchiller on steemit.com/~witnesses or steemworld.org/witnesses.

https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png https://steemitimages.com/DQmarYCHGSBms38CSwf8Be3n56RN16nz8MS6MTSV2jX3TfT/chiller-footer-sh-400x90.png


Comments
Steemie currently dosen't allow you to make comments. If you want to write something, write it using another frontend (like Steemit)
Click there to view this post on Steemit.com
  • @rycharde

    Hi @steemchiller, a modest tip of appreciation: $trendotoken and !trendovoter . Also, please check out my Fourth Nonsense Writing Contest. Thanks!

  • @trendovoter

    Sorry, @rycharde you're not allowed to summon the bot on the post that shared by @steemchiller!


    Support @trendotoken projects by delegating : 100SP , 200SP , 500SP , 1000SP , 2000SP

  • @amico

    Thanks for the database, @steemchiller!

    For others interested, SQL Lite Browser is also available for MacOS and Windows.

    Cheers


    A huge hug from @amico! 🤗

    !trdo

  • @diabolika

    Thanks for this tool. Voted for you as a witness!

  • @davidke20

    Thank you for your contribution. I really appreciate it.

  • @eirik

    If you add your proposal on HIVE you can get your airdrop @steemchiller.

    I would be so happy to see HiveWorld.

  • @leveuf

    Hello, @Steemchiller, I'm sure the new tools will be interesting to see in these weeks. Also I want to make a question, I'm having some trouble creating an account, mostly for recovery but for other project too. I've never created one, is it working, need I to check some info? Best winds for the projects!! :) Thanks a lot!!

  • @stef1

    Ich glaube aufgrund der Ausgangssperren in Zeiten des “Corona“ gibt es nur einen Ausweg für den Menschen, und das ist das Internet. Ich kann mir nicht vorstellen, wie schwer es ohne diesen Luxus wäre. Unser Sohn hat sich für Informatik entschieden, und als Hausaufgaben der Schule sollen sie ein paar Programme schreiben. Ich werde ihm später deinen Link zeigen, vielleicht findet er ihn interessant und fängt an damit zu experimentieren. Vielen Dank für deine Arbeit, und wir freuen uns die neuen Tools auf Steemworld zu sehen.

  • @steemprojects

    This post has been just added as new item to timeline of SteemWorld on Steem Projects.

    If you want to be notified about new updates from this project, register on Steem Projects and add SteemWorld to your favorite projects.

  • @roleerob

    Very good @steemchiller. Great to finally see the beginnings of some database functionality ...

    "... or statistics guy and you want to play around with the data ..."

    ... as this is the category I would fall into. Just a question now of the time to get it open, export the data to MS Access (my preferred DB), etc. We'll see ...

    Spending less and less time "in here" or on "that other one," I also see you have launched into being a Witness. I had removed all of my witness votes. As I have always considered you "one of the good guys," I have voted the + 22 MVests under my control in support of your efforts. Even knowing there is really only one vote that counts ...

    Still ... Out of principle, it is the thought that counts ...

    I wish you well!

  • @luckyali

    missing you on hive as well

  • @funtraveller

    Thanks for your continuous work in developing Steemworld, can't wait to play on these upcoming tools.

  • @sheikh27

    Its giving pleasure to see updates in here, where most of are choice different source and blockchain, always with steemit!

  • @masudrana

    Can you run a api node as a witness owner ,i see their many problem steemit api.It will really helpful for developers if you can run a api like anyx doing.

  • @radaquest

    Thanks for continue improving your amazing tools!

  • @travelwithus

    Gut dass du weiter machst, bin gespannt auf das Tool. Halt die Ohren Steif

  • @networkallstar

    Thanks for the update🙏❤️!!!

  • @famigliacurione

    Thank you for staying on and helping maintain the blockchain. You've always had my support from Day 1. I remember the first day I came to Steem and posted, your website was suggested to me, and I have never stopped using it!

  • @joebabana

    Awesome tool steemworld is. I loved the simplicity and reliability. Does SteemWorld parse everything direct from the Steem blockchain or from a centralize database constantly syncing data from Steem blockchain?

  • @asimpleman

    I missed this one when you posted it. Thanks for being you and creating the best tool created for our Blockchain. I have not felt this good about Steem for three years It is starting to feel cleaner with the departures. Maybe thats just me

  • @trendotoken

    Congratulations @steemchiller, your post successfully recieved 3.66583725 TRDO from below listed TRENDO callers:

    @rycharde earned : 2.2587255 TRDO curation
    @amico earned : 0.185166 TRDO curation


    To view or trade TRDO go to steem-engine.com Join TRDO Discord Channel or Join TRDO Web Site

  • @freiheit50

    Mega!

    !invest_vote

  • @apsu

    Hey, you probably noticed already, but Steemit censored your latest post about softfork.

    But just in case you missed it, I wanted you to know. I'm a small player and we have very different viewpoints, but I truly liked steemworld and it was one of the best tools on Steem.

  • @roleerob

    In whatever "big mess" is currently going "in here" @steemchiller, I just sent you this comment on a post that I actually can no longer find!? Was it censored?

    Anyway, here it is again:


    News flash!! 🙂 My friend ...

    "I am not and I do not plan to be active on H-i-v-e ..."

    ["emphasis" added mine ... ]

    ... you may wish to reconsider. On an "official" post, published a couple of hours ago, we find this:

    "The list of incorrectly excluded accounts are as follows:"

    @steemchiller (and @steemflower) are on it! 👍 I will be looking forward to what you think upon learning this.