The hardfork 25 (codename Equilibrium) should be activated in a few hours (less than 22 but many more than 2 at time of writing 😁) as all top 20 witnesses are now running the v1.25 code on their nodes (see here).
My API servers have also been upgraded to the new code and are now providing HiveSQL with new data. Therefore, I added a few updates to the HiveSQL database.
What's new?
1. Existing table updates
- DynamicGlobalProperties
New columns
| Column | Description |
|---|---|
| current_remove_threshold | number of objects that can be removed in one automatic operation (only applies to situations where many objects can accumulate over time but need to be removed in a single operation f.e. proposal votes) |
| early_voting_seconds | Duration of the first period where all votes are considered equally regarding vote time and the linear rewards curve is applied (equal weight to all voters in that window) - currently 24 hours |
| mid_voting_seconds | Duration of the second period where with reward weight/2 is applied - currently 48 hours |
| max_consecutive_recurrent_transfer_failures | Maximum number of consecutive failures for a recurring transfer before it is automatically canceled |
| max_recurrent_transfer_end_date | Maximum difference between start and end of a recurring payment - currently 730 days (2 years) |
| min_recurrent_transfers_recurrence | Minimum time to elapse between two recurring transfer - currently 24 hours |
| max_open_recurrent_transfers | Maximum number of recurring payments that can be scheduled for execution per account - currently 255 |
- Account
New columns
| Column | Description |
|---|---|
| post_voting_power | Effective HP that are used for curation (vesting_shares - delegated_vesting_shares + received_vesting_shares) |
| post_voting_power_symbol | VESTS |
| pending_transfers | Pending transfers for escrow operations |
| governance_vote_expiration_ts | date and time that the account governance votes for witnesses and proposals will expire |
| delayed_votes_time | date and time that the additional HP recently powered up will be taken into account for governance |
| delayed_votes_val | value of the additional HP that will be taken into account for governance after delay |
| open_recurrent_transfers | Number of recurring transfers scheduled for execution |
Documentation
HiveSQL documentation has been updated and can be viewed at https://docs.hivesql.io
Support
If you have any questions or remarks, support is provided on the HiveSQL Discord Channel.
Happy Hardfork 25!
Check out my apps and services
Vote for me as a witness 
!BEER
!LUV
!PIZZA
@arcange! I sent you a slice of $PIZZA on behalf of @valentin86.
Learn more about $PIZZA Token at hive.pizza (2/10)
So many good things. The perfect combo 🍻❤️🍕
Thank you @valentin86
Congratulations @arcange! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :
Your next payout target is 64000 HP.
The unit is Hive Power equivalent because your rewards can be split into HP and HBD
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCheck out the last post from @hivebuzz:
Your content has been voted as a part of Encouragement program. Keep up the good work!
Use Ecency daily to boost your growth on platform!
Support Ecency
Vote for Proposal
Delegate HP and earn more
@arcange, you were given LUV from @valentin86. About LUV: https://peakd.com/@luvshares http://ipfs.io/ipfs/QmUptF5k64xBvsQ9B6MjZo1dc2JwvXTWjWJAnyMCtWZxqM
Nice ;))
Thank you @denisdenis
Nice !PIZZA
@arcange! I sent you a slice of $PIZZA on behalf of @zottone444.
Learn more about $PIZZA Token at hive.pizza (7/10)