HiveSQL - Hardfork 24 Eclipse Update

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.

ColumnDescription
authorAuthor of the post or comment
permlinkPermlink 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.

ColumnDescription
authorAuthor of the post or comment
permlinkPermlink of the post or comment
payoutAmount of the reward
payout_symbolToken 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
OldNew
total_vesting_fund_steemtotal_vesting_fund_hive
total_vesting_fund_steem_symboltotal_vesting_fund_hive_symbol
total_reward_fund_steemtotal_reward_fund_hive
total_reward_fund_steem_symboltotal_reward_fund_hive_symbol
pending_rewarded_vesting_steempending_rewarded_vesting_hive
pending_rewarded_vesting_steem_symbolpending_rewarded_vesting_hive_symbol
current_sbd_supplycurrent_hbd_supply
current_sbd_supply_symbolcurrent_hbd_supply_symbol
confidential_sbd_supplyDELETED
confidential_sbd_supply_symbolDELETED
sbd_interest_ratehbd_interest_rate
sbd_print_ratehbd_print_rate
sbd_stop_percenthbd_stop_percent
sbd_start_percenthbd_start_percent
  • Accounts
OldNew
sbd_balancehbd_balance
sbd_balance_symbolhbd_balance_symbol
sbd_secondshbd_seconds
sbd_seconds_last_updatehbd_seconds_last_update
sbd_last_interest_paymenthbd_last_interest_payment
savings_sbd_balancesavings_hbd_balance
savings_sbd_balance_symbolsavings_hbd_balance_symbol
savings_sbd_secondssavings_hbd_seconds
savings_sbd_seconds_last_updatesavings_hbd_seconds_last_update
savings_sbd_last_interest_paymentsavings_hbd_last_interest_payment
reward_sbd_balancereward_hbd_balance
reward_sbd_balance_symbolreward_hbd_balance_symbol
reward_steem_balancereward_steem_balance
reward_steem_balance_symbolreward_steem_balance_symbol
reward_vesting_steemreward_vesting_steem
reward_vesting_steem_symbolreward_vesting_steem_symbol
  • Comments
OldNew
percent_steem_dollarspercent_hbd
author_reputationDELETED
reblogged_byDELETED
repliesDELETED
allow_repliesDELETED
root_commentDELETED
modeDELETED
children_abs_rsharesDELETED
  • TxClaimRewardBalances
OldNew
reward_steemreward_hive
  • TxCommentsOptions
OldNew
percent_steem_dollarspercent_hbd
  • TxEscrowReleases
OldNew
sdb_amounthdb_amount
steem_amounthive_amount
  • TxEscrowTransfers
OldNew
sdb_amounthbd_amount
steem_amounthive_amount
  • TxSMTSetupICOTiers
OldNew
steem_units_caphive_units_cap
  • TxSMTSetups
OldNew
steem_units_minhive_units_min
steem_units_caphive_units_cap
  • TxWitnessUpdates
OldNew
props_sbd_interest_rateprops_hbd_interest_rate
  • VOAuthorRewards
OldNew
sbd_payouthbd_payout
steem_payouthive_payout
  • VOCommentBenefactorRewards
OldNew
sbd_payouthbd_payout
steem_payouthive_payout
  • Witnesses
OldNew
sbd_interest_ratehbd_interest_rate
sbd_exchange_rate_basehbd_exchange_rate_base
sbd_exchange_rate_base_symbolhbd_exchange_rate_base_symbol
sbd_exchange_rate_quotehbd_exchange_rate_quote
sbd_exchange_rate_quote_symbolhbd_exchange_rate_quote_symbol
last_sbd_exchange_updatelast_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

H2
H3
H4
3 columns
2 columns
1 column
8 Comments
Ecency