SteemSQL - New DynamicGlobalProperties table

in steemsql •  last year  (edited)

New table added to the database

To simplify the work of SteemSQL users, we added a new table in the database that contains the data returned by the get_dynamic_global_properties API. This API call is used to get the state of the Steem blockchain and its global parameters.

The new table will allow SteemSQL users to optimize their processes and avoid some local processing after retrieving the data they are interested in.

In addition to the fields from the blockchain, we have added some automatically calculated fields.

This is the case of the steem_per_vest column which makes it easy to convert the values expressed in VESTS to their equivalent in STEEM or SP.

Update frequency

The DynamicGlobalProperties table is updated each time SteemSQL start processing new blocks. This means that its data will be updated every 3 seconds. But this value can increase if SteemSQL is a little behind the blockchain and must process several blocks at once.

New database diagram

Here an updated diagram of the database:

For more information, visit SteemSQL website for more information.

A complete list of SteemSQL updates is available here

Thanks for reading!

Do you like my work to support the community?

Vote for my witness

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:  

Good informative article on SteemSQL .
well done my dear friend.