Rubq

Rubq allows access to Google Bigquery the rails way. It uses the Google::Cloud::Bigquery gem behind the scenes and allows for migrations and basic administration.

Usage

This is still very much of a work in progress. You have been warned.

When the first really useful version is available, usage directives will be written here. In the mean time, take a look at the docs below.

What works

• Creating a model migration and its corresponding table in BigQuery
• Inserting a row in a managed table

What does not work

• Everything else

Roadmap to the first usable version

• Write a rubq:migrate task
• Set up schema validation
• Migrations:
  • Streamline usage
  • Implement self.down
  • Create / Delete tables
• Model:
  • #new
  • #delete
  • #update
  • Querying:
    • #all
    • #find
    • #find_by

Installation

Add this line to your application's Gemfile:

gem 'rubq'

And then execute:

$ bundle

Or install it yourself as:

$ gem install rubq

Initialize the library:

# app/config/initializers/rubq.rb

Rubq.configure do |config|
  config.project  =  'my-google-project'
  config.region   =  'eu'
  config.dataset  =  'mybigquerydataset'
end

Documentation

Read the docs

FAQ

Why not an ActiveRecord adapter?

Because Bigquery is by no means a mere SQL database. This gem is just a wrapper around the Google::Cloud::Bigquery gem that provides convenience methods in an ActiveRecord-like fashion.

Contributing

I will add contribution guidelines as soon as this is ready to use.

License

The gem is available as open source under the terms of the MIT License.