A new way to manage multi-tenant applications based on multiples databases
Ruby
Switch branches/tags
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
lib
spec
.gitignore
.rspec
Gemfile
MIT-LICENSE
README.markdown
Rakefile
activerecord-connections.gemspec

README.markdown

ActiveRecord::Connections

ActiveRecord::Connections provides a new way to manage multi-tenant applications based on multiples databases.

Install

Install the activerecord-connections gem:

gem install activerecord-connections

Add this line to Gemfile:

gem 'activerecord-connections'

Runs a bundle install:

bundle install

Usage

ActiveRecord::Connections add this syntax to ActiveRecord::Base:

ActiveRecord::Base.using_connection(connection_name, connection_spec) do
  # Use database connection inside this block
end

If you are using Rails, you could use this way:

class ApplicationController < ActionController::Base
  around_filter :handle_customer

  protected

  def handle_customer(&block)
    customer = Customer.find_by_domain!(request.domain)
    customer.using_connection(&block)
  end
end

class Customer < ActiveRecord::Base
  serialize :connection_spec

  def using_connection(&block)
    ActiveRecord::Base.using_connection(id, connection_spec, &block)
  end
end

Known issues

  • Do not manage activerecord migrations for different databases
  • Similar objects of different connections do not differ
  • Coverage is not the best of the world (you could help easily)
  • You will lose the connection if you call using_connection nested

Sharding and replication

Need sharding or replication? Check out one of these bad boys:

Copyright

Copyright (c) 2011-2015 Gabriel Sobrinho, released under the MIT license.