SteemSQL is a public MS-SQL database with all the blockchain data in it.

Previous posts:

• Introduction post
• SteemSQL - Update 1
• SteemSQL - Update 2 - Language detection
• SteemSQL - Update 3
• SteemSQL - Update 4
• SteemSQL - Update 5
• SteemSQL - Update 6

What’s new?

The hardfork 18.x as brought new operation with it:

• Vesting shares delegation
• Reward claim
• Account creation with delegation
• Reward sharing with other beneficiaries

These changes have been reflected in the database structure, either with new tables or new fields in existing tables.

Here the changes details

• Vesting shares delegation
• Reward claim
• Account creation with delegation
• Reward sharing with other beneficiaries

These changes have been reflected in the database structure, either with new tables or new fields in existing tables.

Here the changes in details

New tables

Two new tables have been created to store delegate_vesting_shares and claim_reward_balance transactions. They are respectively named TxDelegateVestingShares and TxClaimRewardBalances

Changes in TxAccountCreates table

A new field delegation has been added in the table to support the account_create_with_delegation transactions.
These transactions will not be stored in a separate table.
The delegation field value will be set to zero for classic account_create transactions

Changes in Comments table

Two new fields beneficiaries and reblogged_by have been added to the Comments table to reflect the changes in the get_comment API

Thanks for reading!

---

All payout from this post will be dedicated keep SteemSQL running. Thanks for your support.

Support me and my work as a witness by voting for me here!

You like this post, do not forget to upvote or follow me or resteem