Hive SQL

Access data from your ruby/rails application.

Gem Version Inline docs Yard Docs

How to Subscribe

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



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.


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


How to query today's followers:

followers = HiveSQL::Tx::Custom::Follow


How to query today's reblogs:

reblogs = HiveSQL::Tx::Custom::Reblog

Account Witness Proxy

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

proxied ='alice')


How to query comments by application:

comments ='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 @inertia on Hive.

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


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