SteemSQL is a public MS-SQL database with all the blockchain data in it.
- 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
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
children_rshares2 is no longer used and has been deleted.
Changes in table Comments
post_bandwidth is no longer used and has been deleted.
blog_category is no longer used and has been deleted.
Two new fields have been added :
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
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.
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.