The hardfork 26 (codename Evolution) has been activated a few days ago as all top 20 witnesses are now running the v1.26 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.
Thanks to the mirrornet, I have been able to prepare HiveSQL to fully support the new (virtual) operations now available with this new version.
What's new?
While no new operations were added during this hardfork, this is not the case for virtual operations.
As a reminder, Virtual Operations are operations resulting from the activity on the blockchain but, unlike classic operations, they are not initiated by users.
And since hardfork 26, no less than 7 additional Virtual Operations are now available to better monitor what is happening in the blockchain.
New tables
- VOCollateralizedConvertImmediateConversion
| Column | Description |
|---|---|
| owner | The account requesting the conversion |
| requestid | The request identifier |
| hbd_out | Amount of HBD sent to the account |
This virtual operation is triggered after a collateralized_convert operation is issued to convert HIVE to HBD.
Half of the HIVE amount is converted immediately into HBD (using the minimum witnesses price feed for the last 3.5 days) and sent to the owner.
- VODHFConversions
| Column | Description |
|---|---|
| treasury | The account of the DHF |
| hive_amount_in | The amount of HIVE to convert |
| hbd_amount_out | The amount of HBD generated |
When a user transfer HIVE to the DHF account (hive.fund), the amount is immediately converted to HBD and this virtual operation is generated.
This virtual operation is also generated during block processing every day during daily proposal maintenance.
Note: a portion of the HIVE on the treasury balance is converted to HBD and thus increases the funds available for proposals.
- VODHFFundings
| Column | Description |
|---|---|
| treasury | The account of the DHF |
| additional_funds | The amount of HIVE to convert |
| additional_funds_symbol | HBD |
This virtual operation is generated during block processing every proposal maintenance period.
Note: while the DHF receives part of inflation every block, this virtual operation is generated only when there are proposal payouts.
- VOHardforks
| Column | Description |
|---|---|
| hardfork_id | Hardfork number |
This virtual operation is generated during block processing every time new hardfork is activated.
- VOLimitOrderCancelleds
| Column | Description | |
|---|---|---|
| seller | The account who created the order | |
| amount_back | The amount of the cancelled order | |
| additional_funds_symbol | HIVE or HBD |
This virtual operation is generated every time an existing limit order is canceled. It happens on explicit call (first operation), or in the rare case of filling a limit order (second or third operation) when, after filling most of it, the remaining funds are too small (they would round to zero when sold).
This virtual operation is also generated during block processing for orders that reached their expiration time without being filled.
- VOPowRewards
| Column | Description |
|---|---|
| worker | account mining a block |
| reward | amount received |
| reward_symbol | HIVE |
This virtual operation occurs each time a block is produced. It contains the rewards that are given to witnesses (and previously miners) for their work.
- VOProducerMisseds
| Column | Description |
|---|---|
| producer | Name of the witness who missed a block |
This virtual operation is generated during block processing when a witness failed to produce his block on time.
- VOProposalFees
| Column | Description |
|---|---|
| creator | Account creating a proposal |
| treasury | The account of the DHF |
| proposal_id | The proposal identifier |
| fee | The amount paid for creating the proposal |
| fee_symbol | HBD |
This virtual operation is generated every time an account creates a new proposal.
Note: Many of the above mentioned table may currently only contains no records or only records from hardfork 26 and later. It is planned to perform a replay of the blockchain to re-inject data relating to previous events.
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.
Thank you.
Check out my apps and services
~~~ embed:1581362365219491840 twitter metadata:MTMzNTk5NTM3NDUyODUwNzkwN3x8aHR0cHM6Ly90d2l0dGVyLmNvbS8xMzM1OTk1Mzc0NTI4NTA3OTA3L3N0YXR1cy8xNTgxMzYyMzY1MjE5NDkxODQwfA== ~~~
The rewards earned on this comment will go directly to the people( @jlinaresp, @dragon-ti ) sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.
PIZZA Holders sent $PIZZA tips in this post's comments:
@pixresteemer(5/5) tipped @arcange (x1)
Join us in Discord!
Saludos, amigo @arcange, ¿Tendrìa la amabilidad de decirme si esta transacción es segura?
Greetings,dear friend @arcange, would you be kind enough to tell me if this transaction is safe?
It´s in my post:
https://ecency.com/hive-105786/@sayury/hive-open-mic-week-131
Hello @sayury, I do not see any issue with that transactions.
Have a good day
Thanks for this awesome information.
Great one!
Congratulations @arcange! You received a personal badge!
Thank you for participating in the Leo Power Up day.
You can view your badges on your board and compare yourself to others in the Ranking
Check out the last post from @hivebuzz:
Thanks for the info!
I am curious about the HBD conversion processes, as I have not well understood how that occurs. Can you point me to a source that could edify me regarding conversions to and from HBD, please?
I am glad you continue to provide your excellent services on Hive. Few do more to educate me on how Hive works.
Thanks!
When i saw this i became very happy, This new update will really change many things in the Blockchain.
YEs, this hardfork is a major "Evolution"
Evolution is what we need in the world
This HF feels surreal, everything is so smooth and fast.
It's funny to read your comment because all of Hive's hardfork ran smoothly.
Apparently, we are all still traumatized by our terrible past experience with
Steem😂Yeah, you're right the trauma is still there. But it's also notable how fast voting has become.
Great job!
Thank you @genming