A public SQL database with all blockchain data
Database diagram
The Blocks table contains bare block information (timestamp, witness, …)
Each block can contains Transactions
Depending on each transaction type, the associated transaction’s data is stored in the related table.
Full text search
The database has been full text search enabled. This allow fast search of information within post and replies.
For example, if I want to know where anyone has spoken about, me, the following simple query will do the trick
SELECT author, title, body, url FROM TxComments WHERE CONTAINS(title, '@arcange')
Database Connection information:-
Here the information to connect and query the database:
Server: sql.steemsql.com
User: steemit
Password: steemit
How to use it: -
Check this post to see how to create an analysis report with Excel
Support: -
If you need help, have any comment or request, join steemsql group on steemit.chat.
Availability and performance
The SQL server is hosted in a datacenter with 24/7/365 availability.
Available output bandwidth is up to 500Mb/s
New transactions from the latest data blocks are injected in the database every 10 seconds.
The server is currently hosted in a shared infrastructure.
I will monitor server load and if it requires more resources, I will allocate any reward to this post on a dedicated infrastructure.