SteemSQL is a public MS-SQL database with all the blockchain data in it.
Previous posts:
- Introduction post
- A list off all update posts is available on SteemSQL website
What’s new
A few days ago, I announced the availability of the Witnesses table in the SteemSQL database.
The Witnesses table is a non-transactional table which contains a list of all witnesses and related information.
But what about having a full history about witnesses, how they moved in the ranking, when they missed block, how they published pricefeed, when and how long did they deactivated their witness node, ... ?
To be able to answer all those questions, I added the SSWitnesses table to SteemSQL. This table contains a daily snapshot of the most interesting values from the Witnesses table.
Each snapshot is taken every day at 23:59:59 UTC.
SSWitnesses table description
The table contains the following columns:
| Name | Description |
|---|---|
| date | The date at which the snapshot has been taken |
| 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_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 was deactivated |
| account_creation_fee | Proposed cost for the creation of a new account |
| maximum_block_size | Proposed maximum block size |
| 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 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!
SQL is a standard language for storing, manipulating and retrieving data in databases. And your work is well.
I wanna know that why the don't use Mongo Database?
Because MS-SQL offers features not available with MongoDB
True but,
At present all big big company use MongoDB,
Exmp: Facebook
Facebook (And any other company worth their salt) uses MongoDB where it's a good fit, and Postgres/MySQL/OracleDB where they're a good fit.
Steemdata is a mongodb database, however, it's no-where near as flexible as a standard SQL database for this kind of thing.
Just what I needed to see. Thanks for this update
Wow wow wow, nice post brilliant idea and so cool. Keep the good work flowing
This is fantastic.
Is there a way we could explain all of this in far more simpler language for lay men on Steemit?
I think the message would sink faster, deeper and longer that way.