SteemApi

• Add Gem to Gemfile
  • gem 'steem_api', '~> 1.1'
• Bundle Install Gems
  • bundle install

As of 2018-01-23, SteemSQL is moving to a monthly subscription model. To use this gem, you must subscribe to @steemsql and store the credentials as environment variables.

apt-get update && apt-get install -yq freetds-dev freetds-bin

brew install freetds

• gem install steem_api
• export STEEMSQL_HOST=
• export STEEMSQL_USERNAME=
• export STEEMSQL_PASSWORD=
• irb
• require 'steem_api'
• SteemApi::Comment.last

• Account
• Block
• Comment
• Token
• Transaction

How to query today's followers:

followers = SteemApi::Tx::Custom::Follow
followers.following(:ned).today.count

How to query today's "resteems":

reblogs = SteemApi::Tx::Custom::Reblog
reblogs.author(:netuoso).today.count

How to query current accounts that are actively using a proxy:

proxied = SteemApi::Tx::AccountWitnessProxy.active('netuoso')
proxied.pluck(:account)

How to query comments by application:

comments = SteemApi::Comment.app('esteem').where(author: 'good-karma')

• Fork this repo
• Branch off Master and make your changes
• Submit a PR to this repo's Master branch

• WTFPL