HiveSQL
Search…
Introduction
Register your HiveSQL account
Support
Technical informations
Database Diagram
Operations
Virtual Operations
State tables
Full Text Search
Language detection
Tutorials
HiveSQL for Python developers
HiveSQL for PHP developers
HiveSQL for Ruby developers
HiveSQL for Microsoft Excel
HiveSQL Status
Resources
Powered By GitBook
HiveSQL for Ruby developers
​@inertia is developing and maintaining a library for Ruby developers
To use this gem, you must an active @hivesql subscription and store the credentials as environment variables. Read Register your HiveSQL acount to find out about HiveSQL accounts

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')

License

HiveSQL gem is licensed under a Creative Commons CC0 License.
Tutorials - Previous
HiveSQL for PHP developers
Next - Tutorials
HiveSQL for Microsoft Excel
Last modified 1yr ago
Copy link
Outline
License