HiveSQL - Hardfork 24 Eclipse Update

[arcange]

It has now been just under a week since hardfork 24 was activated. After the few small hiccups at the beginning, we can now say that the small problems inherent in this kind of major change have been fixed and that all the applications based on the blockchain are now working in a stable manner.

Eclipse support

HiveSQL also had to undergo a lot of updates to adapt to the new specs and configuration of the blockchain after the hardfork:

• the switch from all steem/sbd references to hive/hbd
• the disappearance of FAT nodes replaced by hivemind
• changes in the behavior of some API calls

Of course, all these changes were implemented in a way that minimized the impact on HiveSQL users.

In this context, although many columns in several tables have been renamed, the database still presents these columns with their old name. This has been put in place to avoid breaking existing scripts and to allow HiveSQL users to adapt their processes.

However, the old columns will be definitely removed on October 31st at midnight (UTC time)! So do not wait too long to update your scripts.

What's new?

Here is the list of all these changes.

1. New tables

Two new tables have been created to store the new virtual operations data.

• VOCommentPayoutUpdates

A comment_payout_update virtual operation is issued when a post or comment reach the end of the payout windows and its final payout values are computed.

Column	Description
author	Author of the post or comment
permlink	Permlink of the post or comment

• VOCommentRewards

A new comment_reward virtual operation is issued each time a reward will be claimed by either the curator or the author of a post or comment.

Column	Description
author	Author of the post or comment
permlink	Permlink of the post or comment
payout	Amount of the reward
payout_symbol	Token symbol of the reward

2. Tables changes

Several tables have been updated by changing the name of some columns and/or deleted unused columns.

• DynamicGlobalProperties

Old	New
total_vesting_fund_steem	total_vesting_fund_hive
total_vesting_fund_steem_symbol	total_vesting_fund_hive_symbol
total_reward_fund_steem	total_reward_fund_hive
total_reward_fund_steem_symbol	total_reward_fund_hive_symbol
pending_rewarded_vesting_steem	pending_rewarded_vesting_hive
pending_rewarded_vesting_steem_symbol	pending_rewarded_vesting_hive_symbol
current_sbd_supply	current_hbd_supply
current_sbd_supply_symbol	current_hbd_supply_symbol
confidential_sbd_supply	DELETED
confidential_sbd_supply_symbol	DELETED
sbd_interest_rate	hbd_interest_rate
sbd_print_rate	hbd_print_rate
sbd_stop_percent	hbd_stop_percent
sbd_start_percent	hbd_start_percent

• Accounts

Old	New
sbd_balance	hbd_balance
sbd_balance_symbol	hbd_balance_symbol
sbd_seconds	hbd_seconds
sbd_seconds_last_update	hbd_seconds_last_update
sbd_last_interest_payment	hbd_last_interest_payment
savings_sbd_balance	savings_hbd_balance
savings_sbd_balance_symbol	savings_hbd_balance_symbol
savings_sbd_seconds	savings_hbd_seconds
savings_sbd_seconds_last_update	savings_hbd_seconds_last_update
savings_sbd_last_interest_payment	savings_hbd_last_interest_payment
reward_sbd_balance	reward_hbd_balance
reward_sbd_balance_symbol	reward_hbd_balance_symbol
reward_steem_balance	reward_steem_balance
reward_steem_balance_symbol	reward_steem_balance_symbol
reward_vesting_steem	reward_vesting_steem
reward_vesting_steem_symbol	reward_vesting_steem_symbol

• Comments

Old	New
percent_steem_dollars	percent_hbd
author_reputation	DELETED
reblogged_by	DELETED
replies	DELETED
allow_replies	DELETED
root_comment	DELETED
mode	DELETED
children_abs_rshares	DELETED

• TxClaimRewardBalances

Old	New
reward_steem	reward_hive

• TxCommentsOptions

Old	New
percent_steem_dollars	percent_hbd

• TxEscrowReleases

Old	New
sdb_amount	hdb_amount
steem_amount	hive_amount

• TxEscrowTransfers

Old	New
sdb_amount	hbd_amount
steem_amount	hive_amount

• TxSMTSetupICOTiers

Old	New
steem_units_cap	hive_units_cap

• TxSMTSetups

Old	New
steem_units_min	hive_units_min
steem_units_cap	hive_units_cap

• TxWitnessUpdates

Old	New
props_sbd_interest_rate	props_hbd_interest_rate

• VOAuthorRewards

Old	New
sbd_payout	hbd_payout
steem_payout	hive_payout

• VOCommentBenefactorRewards

Old	New
sbd_payout	hbd_payout
steem_payout	hive_payout

• Witnesses

Old	New
sbd_interest_rate	hbd_interest_rate
sbd_exchange_rate_base	hbd_exchange_rate_base
sbd_exchange_rate_base_symbol	hbd_exchange_rate_base_symbol
sbd_exchange_rate_quote	hbd_exchange_rate_quote
sbd_exchange_rate_quote_symbol	hbd_exchange_rate_quote_symbol
last_sbd_exchange_update	last_hbd_exchange_update

What's next?

They are still a few things that need to be done to improve HiveSQL, among them:

• Update of the website
• Update of the documentation
• Revival of the HiveSQL status page

If there are other things that you would like to see appear, feel free to leave a comment.

---

Check my apps and services

Vote for me as a witness

Comments

[abh12345]

Thanks @arcange

I don’t think there will be too much impact on my scripts 🙏🏽

[arcange]

We will know for sure from November 1st 😉

[mintrawa]

Thanks for your very useful post even for those not using HiveSQL. Simple, clear and accurate ;) I'm glad you did it!

[arcange]

Thank you @mintrawa

[inertia]

I'm not seeing the new tables VOCommentPayoutUpdates and VOCommentRewards. But I don't need them yet, so no biggie for right now.

[arcange]

Fixed. Thank you for notifying me.

[drniche]

Dear arcange,

sorry for replying in this old post. But I wonder how to check the power up and power down stats using HIVE DB. or is there a description file for all the tables available? Thank you in advance!