[SteemSQL Wrapper] Added the SteemSQL structure

Words
129
Reading
1 min
9y
Listen to this post
~1 min

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.

image.png

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.

Commit

image



Posted on Utopian.io - Rewarding Open Source Contributors

[SteemSQL Wrapper] Added the SteemSQL structure | Ecency