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:
It will also be possible to search for specific criteria. For example, one can search for accounts:
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 )
accounts table currently contains the following columns:
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 of course).
As @amico stated, the SQLite DB Browser is also available for Windows and MacOS ;)
Have fun and Steem on!
Hi @steemchiller, a modest tip of appreciation: $trendotoken and !trendovoter . Also, please check out my Fourth Nonsense Writing Contest. Thanks!
Sorry, @rycharde you're not allowed to summon the bot on the post that shared by @steemchiller!
Thanks for the database, @steemchiller!
For others interested, SQL Lite Browser is also available for MacOS and Windows.
A huge hug from @amico! 🤗
Thanks for this tool. Voted for you as a witness!
Thank you for your contribution. I really appreciate it.
If you add your proposal on HIVE you can get your airdrop @steemchiller.
I would be so happy to see HiveWorld.
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!!
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.
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.
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!
missing you on hive as well
Thanks for your continuous work in developing Steemworld, can't wait to play on these upcoming tools.
Its giving pleasure to see updates in here, where most of are choice different source and blockchain, always with steemit!
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.
Thanks for continue improving your amazing tools!
Gut dass du weiter machst, bin gespannt auf das Tool. Halt die Ohren Steif
Thanks for the update🙏❤️!!!
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!
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?
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
Congratulations @steemchiller, your post successfully recieved 3.66583725 TRDO from below listed TRENDO callers:
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.
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.