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
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Thanks for great work for easily accessing steemit data!
Very nice ! Thanks for this improvement !
Hey @emptyname I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
Yo hago un programa así y a los sumo llego a 15$ jajaja, aunque a esto parece que le falta desarrollo, saludos :D