How to Connect to Steem Blockchain Database Service (MySQL) using LinqPad?

Previously, I have used LinqPad a lot to run a few handy queries to @steemsql server. The @steemsql is a MSSQL server. However, I am more comfortable in MySQL and I found a good MySQL relational database – sbds.privex.io, the Steem Blockchain Database Service

To allow running MySQL queries in LinqPad, you need to Add Connection and click View more Drivers

linqpad-choose-data-context-view-more-drivers

Download and Enable the ÌQ driver`which supports MySQL, Sqlite and Oracle.

linqpad-iq-driver-for-mysql-sqlite-oracle

Getting back to the Add Connection, following the wizard to start a new MySQL connection.

linqpad-choose-iq-mysql-driver

Put in the access details for the Steem Blockchain Database Service in MySQL:

linqpad-iq-connection-mysql-sbds-steem

Then, we can write queries easily, by selecting the connection from sbds.privex.io.steem.steem:

select 
    *
from 
    sbds_tx_comments
where
    author = 'justyy'
order by
    timestamp desc
limit 10

This MySQL queries the steem blockchain to return the last 10 posts (including comments)

linqpad-mysql-example-query-steem-blockchain

You may also like: 怎么样通过 LinqPad 连接到 SBDS – MySQL?

–EOF (The Ultimate Computing & Technology Blog) —