What do you need to create an analysis of Steemit? Of course, it is the access to data and basic knowledge of SQL. But not only this — you also have to know a database structure with its tables and columns.
You can easily get it with SQL:
All tables:
SELECT * FROM sys.views
All columns of a specific table:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tableName'
However, not all users know about this, also, run these queries each time when you want to know about a specific column is very uncomfortable.
But I updated SteemSQL Wrapper — now you can view all tables and columns right on it without running SQL!
Some statistics:
SteemSQL has 403 columns in 43 tables, on average it is about 9 columns in a table.
Posted on Utopian.io - Rewarding Open Source Contributors