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:
1 2 3 4 5 6 7 8 9 | select * from sbds_tx_comments where author = 'justyy' order by timestamp desc limit 10 |
select
*
from
sbds_tx_comments
where
author = 'justyy'
order by
timestamp desc
limit 10This 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) —
loading...
Last Post: Simple but Powerful Simulated Annealing NPM Library (with Demo)
Next Post: PHP Job Searching using Zip-Recruiter API