Hive SQL is ready for the hardfork 25 - Addendum

in HiveDevs3 months ago (edited)

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

current_remove_thresholdnumber 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_secondsDuration 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_secondsDuration of the second period where with reward weight/2 is applied - currently 48 hours
max_consecutive_recurrent_transfer_failuresMaximum number of consecutive failures for a recurring transfer before it is automatically canceled
max_recurrent_transfer_end_dateMaximum difference between start and end of a recurring payment - currently 730 days (2 years)
min_recurrent_transfers_recurrenceMinimum time to elapse between two recurring transfer - currently 24 hours
max_open_recurrent_transfersMaximum number of recurring payments that can be scheduled for execution per account - currently 255
  • Account

New columns

post_voting_powerEffective HP that are used for curation (vesting_shares - delegated_vesting_shares + received_vesting_shares)
pending_transfersPending transfers for escrow operations
governance_vote_expiration_tsdate and time that the account governance votes for witnesses and proposals will expire
delayed_votes_timedate and time that the additional HP recently powered up will be taken into account for governance
delayed_votes_valvalue of the additional HP that will be taken into account for governance after delay
open_recurrent_transfersNumber of recurring transfers scheduled for execution


HiveSQL documentation has been updated and can be viewed at


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



@arcange! I sent you a slice of $PIZZA on behalf of @valentin86.

Learn more about $PIZZA Token at (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) :

You received more than 62000 HP as payout for your posts and comments.
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 STOP

Check out the last post from @hivebuzz:

Hive Power Up Day - July 1st 2021 - Hive Power Delegation

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! I sent you a slice of $PIZZA on behalf of @zottone444.

Learn more about $PIZZA Token at (7/10)