SteemSQL is a public MS-SQL database with all the blockchain data in it.
Previous posts:
- 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
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:
| Name | Description |
|---|---|
| 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 STM1111111111111111111111111111111114T1Anm means the witness has been deactivated and will no more be scheduled for block production |
| account_creation_fee | Proposed cost for the creation of a new account |
| account_creation_fee_symbol | STEEM |
| 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_base_symbol | SBD |
| sbd_exchange_rate_quote | Proposed value for the ratio between SBD and STEEM for rewards |
| sbd_exchange_rate_quote_symbol | STEEM |
| 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.
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!
thanks for the update
a very interesting post @arcange the writing is very clear
Thank to @adm , respect reply @spaminator
nice
Generic comments could be mistaken for spam.
Your Reputation Could be a Tasty Snack with the Wrong Comment!
Thank You! ⚜
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
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
Very nice blog post. It gives a lot of information. Thank you @arcange for the all time support
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.