Hive SQL for Ruby and Rails Applications

Access HiveSQL.io data from your ruby/rails application.

Gem repository: https://github.com/inertia186/hive_sql

How to Subscribe

Note: HiveSQL is a monthly subscription. To use this gem, you must subscribe to Hive account@hivesql and store the credentials as environment variables.

See: https://hivesql.io

Installation

First, install ruby. One way to do this is install rvm. Once ruby is installed, install hive_sql with the gem command:

gem install hive_sql

Or, add it to your Gemfile:

gem 'hive_sql'

How To Use (Standalone)

gem install hive_sql
export HIVESQL_HOST=<your hivesql host>
export HIVESQL_USERNAME=<your hivesql username>
export HIVESQL_PASSWORD=<your hivesql password>
hive_sql top upvoted

The above example will query the top upvoted content for the last 7 days.

Models

• Account
• Block
  • Transaction
    • various operations
• Comment
• Community
  • Role
  • Subscriber
• Follower
• Reblog
• Tag
• Token
• Witness

Followers

How to query today's followers:

followers = HiveSQL::Tx::Custom::Follow
followers.following(:alice).today.count

Reblog

How to query today's reblogs:

reblogs = HiveSQL::Tx::Custom::Reblog
reblogs.author(:alice).today.count

Account Witness Proxy

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

proxied = HiveSQL::Tx::AccountWitnessProxy.active('alice')
proxied.pluck(:account)

Applications

How to query comments by application:

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

Get in touch!

If you're using HiveSQL with ruby, I'd love to hear from you. Drop me a line and tell me what you think! I'm Hive account@inertia on Hive.

Please note that this gem just provides access to the HiveSQL data services are provided by Hive account@arcange.

License

I don't believe in intellectual "property". If you do, consider the HiveSQL gem as licensed under a Creative Commons CC0 License.