Hive SQL is ready for the hardfork 25

avatar
(Edited)

The hardfork 25 (codename Equilibrium) should be activated in a few weeks. With these harfork will come many changes in the blockchain data which must obviously be passed on to HiveSQL.

Therfore HiveSQL has undergo a lot of updates to be prepared to the new specs and configuration of the blockchain after the hardfork.

Of course, all of these changes have been implemented in such a way as to minimize the impact on users, apps and processes relying on HiveSQL, which means... they shouldn't be affected at all!

What's new?

Here is the list of all these changes.

1. New Operation tables

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

  • TxCollateralizedConverts

The collateralized_convert operation is similar to the convert operation and instructs the blockchain to convert HIVE to HBD. The operation is performed after a 3.5 days delay, but the owner gets HBD immediately. The price risk is cushioned by extra HIVE. After actual conversion takes place the excess HIVE is returned to the owner.

ColumnDescription
ownerThe account requesting the conversion
requestidA request identifier
amountThe amount of HIVE to convert
amount_symbolHIVE
  • TxRecurrentTransfers

The recurrent_transfer operation creates/updates/removes a recurrent transfer (Transfers any liquid asset every fixed amount of time from one account to another). If the amount is set to 0, the recurrent transfer is be deleted. If there is already a recurrent transfer matching from and to, the recurrent transfer is updated.

ColumnDescription
fromAccount to transfer an asset from
toAccount to transfer an asset to
amountThe amount of asset to transfer
amount_symbolThe symbol of the asset to transfer
memocommunication that accompanies the transfer. The memo is plain-text, any encryption on the memo is up to a higher-level protocol
recurrenceHow often will the payment be triggered (hours)
executionsHow many times the recurrent payment will be executed
extensionsreserved for future use

2. New Virtual Operation tables

  • VOAccountCreateds

This virtual operation is issued each time a new account has been successfully created.

ColumnDescription
new_account_namename of the newly created account
creatorname of the account creator
initial_vesting_sharesAmount of VESTS given to the created account
initial_vesting_shares_symbolVESTS
initial_delegationAmount of VESTS delegated if created with account_create_with_delegation
initial_delegation_symbolVESTS
  • VOChangedRecoveryAccounts

This virtual operation is issued when the blockchain effectively changes the recovery account of an account after it issued such a request.

ColumnDescription
accountaccount who changed its recovery account
old_recovery_accountold recovery account
new_recovery_accountnew recovery account
  • VOCommentsVotes

This virtual operation is issued when a vote on a post or comment becomes effective.

ColumnDescription
voteraccount performing the vote
authorauthor of the post or comment being voted
permlinkpermlink of the post or comment being voted
weightdefines the score this vote receives, used by vote payout calc. 0 if a negative vote or changed votes
rsharesThe number of rshares this vote is responsible for
total_vote_weightthe total weight of voting rewards. It is used to calculate the pro-rata share of curation payouts
pending_payoutpotential payout of related comment at the moment of this vote
pending_payout_symbolHBD
  • VOExpiredAccountNotifications

This virtual operation is issued when governance votes for an account have expired and are removed.

ColumnDescription
accountAccount for who governance votes have expired
  • VOFailedRecurrentTransfers

This virtual operation is issued when a recurrent transfer has failed to be executed.

ColumnDescription
fromAccount to transfer an asset from
toAccount to transfer an asset to
amountThe amount of asset to transfer
amount_symbolThe symbol of the asset to transfer
memo
consecutive_failuresHow many times the recurrent payment failed to be executed
remaining_executionsHow many times the recurrent payment should still be executed
deletedIndicates that the recurrent transfer was deleted due to too many consecutive failures
  • VOFillCollateralizedConvertRequests

This virtual operation is issued when a HIVE to HBD conversion is completed.

ColumnDescription
ownerAccount requesting the conversion
requestidconversion request identifier
amount_inAmount of hive to be converted
amount_in_symbolHIVE
amount_outAmount of HBD to be received
amount_out_symbolHBD
excess_collateralexcess HIVE returned to the owner
excess_collateral_symbolHIVE
  • VOFillRecurrentTransfers

This virtual operation is issued when a recurrent transfer is executed.

ColumnDescription
fromaccount sending assets
toaccount receiving assets
amountamount sent
amount_symbolasset symbol
memoa communication that accompanies the transfer. The memo is plain-text, any encryption on the memo is up to a higher-level protocol
remaining_executionsNumber of remaining executions
  • VOTransferToVestingCompleteds

This virtual operation is issued when a power-up is finally taken into account for governance votes.

ColumnDescription
from_accountaccount powering up HIVE
to_accountaccount receiving VESTS
hive_vestedamount of HIVE powered up
hive_vested_symbolHIVE
vesting_shares_receivedamount of VESTS received
vesting_shares_received_symbolVESTS

Documentation

The HiveSQL documentation has been updated accordingly 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.

Thank you.

Support the HiveSQL proposal to keep it free for all
Vote for the proposal on PeakD
Vote for the proposal on Ecency
Vote for the proposal using HiveSigner

Check out my apps and services


Vote for me as a witness



0
0
0.000
12 comments
avatar

pixresteemer_incognito_angel_mini.png
Bang, I did it again... I just rehived your post!
Week 59 of my contest just started...you can now check the winners of the previous week!
!BEER
1

0
0
0.000
avatar

This is great, I have reblogged your post.

0
0
0.000
avatar

Thank you @darkflame

0
0
0.000
avatar

No thank you for your hard work, I wish I knew more of the programming languages but I am happy to give you my upvotes and support your efforts here. I consider Hive to be one of the most important projects in the world right now, and some of those features are really cool. Like recurring transactions, that will be so useful!

0
0
0.000
avatar

collateralized_convert

This is great because it means we can get HBD immediately for Hive even if the conversion takes 3 days underneath the hood.

0
0
0.000