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 @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
- Transaction
- 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 @inertia on Hive.
Please note that this gem just provides access to the HiveSQL data services are provided by @arcange.
License
I don't believe in intellectual "property". If you do, consider the HiveSQL gem as licensed under a Creative Commons CC0 License.