SteemSQL database is a fantastic resource. It takes all the data from the STEEM blockchain and organised it into a structured SQL database.
The operator of this service is @arcange and there are many posts on his blog documenting the database, I recommend you check the out
You can find the latest post here
https://steemit.com/steemsql/@arcange/steemsql-update-11
(Also is a witness - consider giving him a witness vote to keep this service going)
At the moment I have to limit my data posts, because using Power BI to query the database is causing a problem. The M language used to create the query does not convert to a (NOLOCK) query. This results in the database hanging.
If you are using Power BI or Excels Power Query please note you should also restrict the queries you are running to SteemSQL
After searching the official Power BI forum, the only solution is to this is to use SQL and enter the query as an SQL query. This can be added in the advanced section when initially connecting to the database
What if I don’t know SQL?
I don’t know SQL, so if you don’t, well you not on your own. But if we are going to analyse the SQL database then we really need to know how.
has some really good articles. I bookmarked them as I knew they would come in handy. This is a fantastic resource. Kudos to
, please do keep these coming.
https://steemit.com/steemit/@carlgnash/curate-like-a-boss-a-beginner-s-guide-to-querying-steemsql-by-a-complete-sql-beginner
In addition to this, for a deeper dive on SQL let me recommend the SQL module form the Microsoft Data Science Professional Program. You can complete this course free, however if you want a certificate then you will have to pay $99
https://www.edx.org/course/querying-data-transact-sql-microsoft-dat201x
Let’s Share Codes
Moving forward as I learn SQL and use it to query the Steemit SQL database I will share codes and tutorials using https://utopian.io/.
Utopian.io is an app on the Steemit Blockchain. Created by and can be found
. It allows anyone contribute to open source projects and be rewarded with STEEM
I am also going to do some posts detailing the contents on the tables in the SQL database as an easy reference resource for fellow Steemains
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...