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
- SteemSQL - Update 7
What’s new?
1. Several tables have been updated to reflect the last changes in the blockchain data structure
Here the changes in details:
Changes in table Account
The field children_rshares2 is no longer used and has been deleted.
Changes in table Comments
The field post_bandwidth is no longer used and has been deleted.
The field blog_category is no longer used and has been deleted.
Two new fields have been added : tags_usage and guest_blog
2. The block's timestamp field has been duplicated in related tables
To retrieve the date and time associated with a transaction, it was necessary to make a join between the tables Tx… and the table Transactions and another join between the table Transactions and the table Blocks.
Despite the fact that best practices in database design advocate not duplicating a data field across different tables, it was clear that this design was a bit cumbersome when writing complex queries.
This is why I decided to duplicate the timestamp field from each block to all tables containing transactions (Tx…). This will make queries easier to write and to understand. It will also speed up a little bit the processing of these queries.
3. Performance improvement
Several indexes have been created to improve overall queries performances.
Support
If you need help, have any comment or request, you can contact me in SteemSQL channel on steemit.chat.
Thanks for reading.
Thanks for your support.
footer created with steemitboard - click any award to see my board of honor
Support my work as a witness by voting for me here! 