[SteemSQL] A public SQL database with all blockchain data - UPDATE3steemCreated with Sketch.

in steemit •  last year

SteemSQL is a public full-text search enabled MS-SQL database with all the blockchain data.

Here is a quick recap of the previous SteemSQL posts:

What’s new?

Hardfork 0.16 support

With the forthcoming hardfork , some small changes have been required to allow the database injector to run smoothly.

Changes in the Accounts table:

  • pending_reset_authority column has been deleted
  • reset_request_time column has been deleted
  • primary key changed from column id to column name

Changes in the Comments table:

  • post column has been deleted. It was redundant with the depth field.
    You can check for depth = 0 for a post and depth > 0 for a comment
  • percent_steem_dollars column has been changed from smallint to int

Accounts table updated more frequently

Check update 1 to get more information on how this table is populated and updated.

Close monitoring of the server, which is now running for 3 months, has shown that the server is not overloaded by the many queries it has to handle. Therefore, I have increased the Accounts table update frequency which now triggers every 5 minutes.

Support

If you need help, have any comment or request, you can contact in SteemSQL channel on steemit.chat.

Thanks for reading!


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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  Trending

Love SteemSQL

This post has been ranked within the top 80 most undervalued posts in the second half of Nov 30. We estimate that this post is undervalued by $6.03 as compared to a scenario in which every voter had an equal say.

See the full rankings and details in The Daily Tribune: Nov 30 - Part II. You can also read about some of our methodology, data analysis and technical details in our initial post.

If you are the author and would prefer not to receive these comments, simply reply "Stop" to this comment.