HiveSQL Update - New proposals tables

in HiveDevs3 years ago (edited)

There has been a lot of discussion about the proposals recently, especially about the proposals relating to the @hbdstabilizer project, but also following the de-funding and re-funding of the HiveSQL proposal.

That's why, over the last few days, I've been working on proposal data, some of which was still missing in HiveSQL.

While preparing this post, I realized that there was already a whole series of updates that I had already done in the database but for which I had not published a post yet. This is what happens when you are more of a worker than a blogger. Now is the time to rebalance this a bit.

What's new?

New tables

Several new table have been added to the database:

Table nameDescription
TxProposalCreatesCreation of a new proposal
TxProposalUpdatesUpdate of the data of a proposal
TxProposalRemovesRemoval of a proposal
TxProposalVoteUpdatesVote and Unvote performed by user on one or several proposals

The names of the columns in the tables and their purpose are self-explanatory enough that I don't have to list them here. This will be added to the documentation I will release soon.

The above tables are "transactional tables", meaning a new row is created each time a new transaction is broadcasted to the blockchain.

I also created two additional tables:

Table nameDescription
ProposalsList of ALL proposal and their data (including deleted ones)
ProposalsApprovalsList of the proposals that are approved by each user

The two above tables are "state tables", meaning they reflect the result of the transactions that have been broadcasted to the blockchain.

The big advantage of these last two tables is that they keep the data relating to the proposal which are deleted or expired. This is information that Hive APIs currently do not provide!

Steem columns removed

Until now, several tables of the database still contained certain columns relating to the other blockchain (whose name must not be said), this in order to not allow Hive applications previously working with SteemSQL to update them with complete peace of mind when we forked.

As it has been a year since we split up, it was time to draw the final line and remove these no longer needed columns. It is therefore now officially done.


Support the Hive proposal

Vote for the proposal on PeakD
Vote for the proposal on Ecency
Vote for the proposal using HiveSigner

If you have any questions or remarks, support is provided on the HiveSQL Discord Channel.


Check out my apps and services


Vote for me as a witness

Sort:  

Amazing :) will need this . Definitely helpful .

Posted Using LeoFinance Beta

I don't get all the code stuff....but without great folks like you, we would all be in the dark. Thank you for what you do(whatever that is exactly 😁😁) to keep us up and running AND constantly ahead of that other chain.😁

Goo up hive

Nice!
Can you add a supply info please... this is now even more chalenging to follow.

Supply info is already available in DynamicGlobalProperties.
Do you rather want a history of these values? If so, is a daily snapshot enough?

Yes, a snapshot will be enough

As it has been a year since we split up, it was time to draw the final line and remove these no longer needed columns. It is therefore now officially done.

Maybe now we can get some closure

That's what I did.

Congratulations @arcange! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You have been a buzzy bee and published a post every day of the week

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

To support your work, I also upvoted your post!

Check out the last post from @hivebuzz:

Hive Tour Update - Governance
Support the HiveBuzz project. Vote for our proposal!

Nice one brother, are you on Twitter? I’ll like to direct message you.

You can contact me on Discord or Telegram

Thank you for these update sir im just new here! Godbless