Connecting to the SteemSQL database via R

in #cryptocurrency6 years ago

As discussed in the previous post (https://busy.org/@verodato/steem-blockchain-the-forest-and-the-trees), we’re going to use the SteemSQL service to get the Steem blockchain data. The connection to the database will be made using the R software (https://www.r-project.org/). It’s a widely used open source statics and programming language and environment. Remember to download the free version of the RStudio editor if it is your first time trying R (https://www.rstudio.com/). You’ll need to install the RJDBC package too.

The R code to connect to the SQL server is the following (“user” and “password” are supplied by the SteemSQL service upon payment):

    require(RJDBC)
    drv <- JDBC("net.sourceforge.jtds.jdbc.Driver",
             "/home/user/Downloads/jtds-1.2.8-dist/jtds-1.2.8.jar") 
    conn <- dbConnect(drv, "jdbc:jtds:sqlserver://vip.steemsql.com;DatabaseName=DBSteem", domain="windows domain", user="username", password="userpassword")

Once connected, we can make a query, for example, to check what is the total number of accounts in the Steem blockchain:

    sqltxt <- "SELECT COUNT(ID) FROM Accounts"
    dbGetQuery(conn, sqltxt)

That’s it! Quite easy (if you had no trouble installing stuff). In the next post we’ll see how to get Steem delegation data and how to calculate time series from it. If you have any doubt about installing R, R packages, RStudio, MS drive, put it in the comments below and I’ll try to help you.

Sort:  

Go here https://steemit.com/@a-a-a to get your post resteemed to over 72,000 followers.

Wonderful and useful information you provided. THANKS FOR THIS

You got a 5.92% upvote from @upmewhale courtesy of @verodato!

Earn 100% earning payout by delegating SP to @upmewhale. Visit http://www.upmewhale.com for details!

Want to start trading with comfort?
https://masscoinapp.com/ - the best thing for it.
Read the description on the main page!

This is a nice inquiry!!!!!
950,000 user are on steemit,,
Active user little,,
i waited for your next post..Thanks a lot,,
@follow you as a new,,

Hello, world!
Today i will write about MassCoin - software for checking the threshold value of any cryptocurrency with comfort.
masscoinapp.com - start trade with pleasure.

You got a 4.07% upvote from @postpromoter courtesy of @verodato!

Want to promote your posts too? Check out the Steem Bot Tracker website for more info. If you would like to support the development of @postpromoter and the bot tracker please vote for @yabapmatt for witness!

You got a 30.55% upvote from @upme thanks to @verodato! Send at least 3 SBD or 3 STEEM to get upvote for next round. Delegate STEEM POWER and start earning 100% daily payouts ( no commission ).

This post has received a 39.98 % upvote from @booster thanks to: @verodato.

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.039
BTC 70112.96
ETH 3549.99
USDT 1.00
SBD 4.71