HiveSQL - Dynamic Global Properties

Let's try to understand what Hive dynamic global properties are. According to Hive Developer Portal:

Dynamic Global Properties represent a set of values that are calculated during normal chain operations and reflect the current values of global blockchain properties.

The API returns an object containing information that changes every block interval such as the head block number, the total vesting fund, etc.

Ok. So this is my understanding based on the above description.

These are values/properties that have to do with Hive blockchain itself as a whole, rather than individual accounts or transactions on the chain.
And these values more likely to change after each block production.
There is an API call that returns these values when needed.

Feel free to go to https://hivelibrarian.herokuapp.com/ and click "Get DGP" in dynamic global properties section to see what they are.

First, I tried to get these dynamic global properties using HiveSQL. Why? Because I needed one or two of them in my code. About that in a little bit.

But then I also tried to get the same dynamic global properties using Beem and using Lighthive. I didn't get all identical results from them. And I don't mean identical values, I mean I didn't get same amount of properties returned.

Let's start with Lighthive.

from lighthive.client import Client 
import pprint 
 
client = Client() 
props = client.get_dynamic_global_properties() 
pprint.pprint(props) 
print(len(props))

This returned 38 properties with their values.

Now let's try with Beem.

from beem import Hive 
from beem.nodelist import NodeList 
from beem.amount import Amount 
import pprint 
nodelist = NodeList() 
nodelist.update_nodes() 
nodes = nodelist.get_hive_nodes() 
hive = Hive(node=nodes) 
 
globalprops = hive.get_dynamic_global_properties() 
count = 1 
for prop in globalprops: 
    print(count, prop, globalprops[prop]) 
    count +=1 
print(count-1)

Beeem returned 39 properties with their values. It seems LightHive doesn't include id. Ok, I don't need id anyway.

But when we try to get the same dynamic global properties from HiveSQL we get 58 properties with values returned. Let's try.

import os 
import pymssql 
import datetime as dt 
from pprint import pprint 
 
def hive_sql(SQLCommand, limit): 
    db = os.environ['HIVESQL'].split() 
    conn = pymssql.connect(server=db[0], user=db[1], password=db[2], database=db[3]) 
    cursor = conn.cursor() 
    cursor.execute(SQLCommand) 
    result = cursor.fetchmany(limit) 
    conn.close() 
    return result 
 
SQLCommand = ''' 
SELECT COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'DynamicGlobalProperties' 
''' 
result = hive_sql(SQLCommand, 100) 
col_names = [] 
for col_name in result: 
    col_names.append(col_name[0]) 
 
SQLCommand = ''' 
SELECT * 
FROM DynamicGlobalProperties 
''' 
result = hive_sql(SQLCommand, 100) 
col_values = [] 
for col_value in result[0]: 
    col_values.append(col_value) 
 
dgp = dict(zip(col_names, col_values)) 
 
pprint(dgp) 
print(len(dgp))

The returned results for dynamic global properties from HiveSQL are at the end of the post.

As I was trying to understand why HiveSQL returns more properties compared to Beem or LightHive, I noticed how HiveSQL splits some of the properties into two, especially to differentiate the asset names like Hive, HBD, and VESTS. That's kinda helpful. I like that.

However, that's not it. There are more properties that HiveSQL returns that do not appear on returned results from Beem and LightHive at all. These properties are:

hive_per_vest
smt_creation_fee
smt_creation_fee_symbol
price_hive_usd
price_hbd_usd
steem_per_vest
current_sbd_supply
current_sbd_supply_symbol
confidential_supply
confidentail_supply_symbol
confidential_hbd_supply

I don't know there is this discrepancy. But it a helpful discrepancy. Because I have been using hve_per_vest a lot to convert vests to hp. That is super helpful. I can also see price_hive_usd and price_hbd_usd to be really helpful.

I am assuming those referring to steem, sbd, and smts might be old column names. I don't know. If anybody can explain that will be great. Especially, please tell me what confidential_supply is? :)

Anyway, it is great to have easy access to these properties and values. You never know when you might need them. Now everybody can get them. Hive is not confidential. lol

One more thing.

Hive Developer Portal is still referring to assets as sbd and steem. That probably needs to be updated to HBD and Hive.

Here is the list of dynamic global properties and current values:

Count	Dynamic Global Properties	Values
1	ID	0
2	head_block_number	51287980
3	head_block_id	030e97ac48953943476345f5f696f4769fd83405
4	time	2021-02-13 06:55:57
5	current_witness	someguy123
6	total_pow	514415
7	num_pow_witnesses	172
8	virtual_supply	404250158.487
9	virtual_supply_symbol	HIVE
10	current_supply	383471109.892
11	current_supply_symbol	HIVE
12	current_hbd_supply	4571390.691
13	current_hbd_supply_symbol	HBD
14	total_vesting_fund_hive	143338347.811
15	total_vesting_fund_hive_symbol	HBD
16	total_vesting_shares	272575563468.187000
17	total_vesting_shares_symbol	VESTS
18	total_reward_fund_hive	0.000
19	total_reward_fund_hive_symbol	HBD
20	total_reward_shares2	0
21	pending_rewarded_vesting_shares	776806579.051573
22	pending_rewarded_vesting_shares_symbol	VESTS
23	pending_rewarded_vesting_hive	394192.544
24	pending_rewarded_vesting_hive_symbol	HIVE
25	hbd_interest_rate	0
26	hbd_print_rate	10000
27	maximum_block_size	65536
28	required_actions_partition_percent	0
29	current_aslot	51454719
30	recent_slots_filled	340282366920938463463374607431768211455
31	participation_count	128
32	last_irreversible_block_num	51287965
33	vote_power_reserve_rate	10
34	target_votes_per_period	0
35	delegation_return_period	432000
36	reverse_auction_seconds	300
37	available_account_subsidies	21137701
38	hbd_stop_percent	1000
39	hbd_start_percent	900
40	next_maintenance_time	2021-02-13 07:29:45
41	last_budget_time	2021-02-13 06:29:45
42	content_reward_percent	6500
43	vesting_reward_percent	1500
44	sps_fund_percent	1000
45	sps_interval_ledger	33.995
46	sps_interval_ledger_symbol	HBD
47	downvote_pool_percent	2500
48	hive_per_vest	0.0005258664
49	smt_creation_fee	0.000
50	smt_creation_fee_symbol	HBD
51	price_hive_usd	0.24040000
52	price_hbd_usd	1.40700000
53	steem_per_vest	0.0005258664
54	current_sbd_supply	4571390.691
55	current_sbd_supply_symbol	SBD
56	confidential_supply	0.000
57	confidential_supply_symbol	HIVE
58	confidential_hbd_supply	0.000

Posted Using LeoFinance ^Beta