SteemSQL is a public MS-SQL database with all the blockchain data in it.
- Introduction post
- SteemSQL - Update 1
- SteemSQL - Update 2
- SteemSQL - Update 3
- SteemSQL - Update 4
- SteemSQL - Update 5
- SteemSQL - Update 6
- SteemSQL - Update 7
- SteemSQL - Update 8
- SteemSQL - Update 9
- SteemSQL - Update 10
- SteemSQL - Update 11
- SteemSQL - Update 12
- SteemSQL - Update 13
Witnesses table has been added to the database.
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:
|name||Account name of the witness|
|votes_count||Number of votes the witness received|
|url||The URL of the witness presentation post|
|votes||Total amount of VEST from voters|
|total_missed||Number of blocks missed|
|last_aslot||This value indicate when the witness was last scheduled for block production|
|last_confirmed_block_num||Block number of the last block signed by the witness|
|signing_key||Current signing key use by the Witness. A value of |
|account_creation_fee||Proposed cost for the creation of a new account|
|maximum_block_size||Proposed maximum block size. The greater, the more information and transactions the blockchain can store in each block|
|sbd_interest_rate||Proposed interest rate to rewards users holding SBD|
|sbd_exchange_rate_base||Proposed cost in SBD to buy 1 STEEM|
|sbd_exchange_rate_quote||Proposed value for the ratio between SBD and STEEM for rewards|
|last_sbd_exchange_update||Last time the witness updated its pricefeed|
|running_version||Current version of the witness node|
|hardfork_version_vote||Current version of the hardfork supported by the witness|
|hardfork_time_vote||Time of vote from the witness for the latest supported hardfork|
Here an updated diagram of the database:
Visit SteemSQL.com website for more information.
Thanks for reading.