STEEMSQL - Update 14 - Witnesses table available

in steemsql •  last year

SteemSQL is a public MS-SQL database with all the blockchain data in it.

Previous posts:

What's new

A new Witnesses table has been added to the database.

The Witnesses table is a non-transactional table which contains a list of all witnesses and related information. The table content is updated every witness round (i.e. every 63 seconds as there are 21 witnesses producing a block every 3 seconds in each round)

This table will allow my friend @drakos to directly grab all data required for his witness page from SteemSQL. I guess many other SteemSQL’s users will find useful to have the information about witnesses at hand rather than to crawl the blockchain to get it.

Witnesses table description

The table contains the following columns:

nameAccount name of the witness
votes_countNumber of votes the witness received
urlThe URL of the witness presentation post
votesTotal amount of VEST from voters
total_missedNumber of blocks missed
last_aslotThis value indicate when the witness was last scheduled for block production
last_confirmed_block_numBlock number of the last block signed by the witness
signing_keyCurrent signing key use by the Witness. A value of STM1111111111111111111111111111111114T1Anm means the witness has been deactivated and will no more be scheduled for block production
account_creation_feeProposed cost for the creation of a new account
maximum_block_sizeProposed maximum block size. The greater, the more information and transactions the blockchain can store in each block
sbd_interest_rateProposed interest rate to rewards users holding SBD
sbd_exchange_rate_baseProposed cost in SBD to buy 1 STEEM
sbd_exchange_rate_quoteProposed value for the ratio between SBD and STEEM for rewards
last_sbd_exchange_updateLast time the witness updated its pricefeed
running_versionCurrent version of the witness node
hardfork_version_voteCurrent version of the hardfork supported by the witness
hardfork_time_voteTime of vote from the witness for the latest supported hardfork

Here an updated diagram of the database:

Visit website for more information.

Thanks for reading.

footer created with steemitboard - click any award to see my board of honor

Support me and my work as a witness by voting for me here!

You can also vote for my witness with SteemConnect

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

thanks for the update

a very interesting post @arcange the writing is very clear
Thank to @adm , respect reply @spaminator

It's jsut a little expensive for me.

It's great that you are sharing this info... I will look into SQL DB.

Impressive work

wow thats great i m a computer science software engineer i like that so much to know your that post thats amazing and thats looking like so good for our future

This one is interesting @arcange. Keep sharing & steeming. God bless!
Don't forget to Upvote & Resteem me also @mayann.

It's just a great think. Thanks.

Wow, This is very good post.



Generic comments could be mistaken for spam.

Your Reputation Could be a Tasty Snack with the Wrong Comment!

Thank You! ⚜

Very nice blog post. It gives a lot of information. Thank you @arcange for the all time support