Project

hive_sql

0.0
Low commit activity in last 3 years
No release in over a year
Rails compatible gem that provides full DB connection and models to HiveSQL.io
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 2.0, >= 2.0.1
~> 5.10, >= 5.10.3
~> 0.6, >= 0.6.4
~> 0.5, >= 0.5.5
~> 0.11, >= 0.11.2
~> 0.9, >= 0.9.16
~> 1.0, >= 1.0.0
~> 1.0, >= 1.0.0
~> 13.0, >= 13.0.6

Runtime

 Project Readme

Hive SQL

Access HiveSQL.io 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.

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 @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 Radiator as licensed under a Creative Commons CC0 License.