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.
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 |
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.
| 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 |
| 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 |
| 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 |
| Old | New |
|---|
| reward_steem | reward_hive |
| Old | New |
|---|
| percent_steem_dollars | percent_hbd |
| Old | New |
|---|
| sdb_amount | hdb_amount |
| steem_amount | hive_amount |
| Old | New |
|---|
| sdb_amount | hbd_amount |
| steem_amount | hive_amount |
| Old | New |
|---|
| steem_units_cap | hive_units_cap |
| Old | New |
|---|
| steem_units_min | hive_units_min |
| steem_units_cap | hive_units_cap |
| Old | New |
|---|
| props_sbd_interest_rate | props_hbd_interest_rate |
| Old | New |
|---|
| sbd_payout | hbd_payout |
| steem_payout | hive_payout |
- VOCommentBenefactorRewards
| Old | New |
|---|
| sbd_payout | hbd_payout |
| steem_payout | hive_payout |
| 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
