Connecting Rails 3.1 with Multiple Databases

by

To Wukerplank’s answer, you can also put the connection details in database.yml like usual with a name like so:

log_database_production:
  adapter: mysql
  host: other_host
  username: logmein
  password: supersecret
  database: logs

Then in your special model:

class AccessLog < ActiveRecord::Base
  establish_connection "log_database_#{Rails.env}".to_sym
end

To keep those pesky credentials from being in your application code.

Edit: If you want to reuse this connection in multiple models, you should create a new abstract class and inherit from it, because connections are tightly coupled to classes (as explained here, here, and here), and new connections will be created for each class.

If that is the case, set things up like so:

class LogDatabase < ActiveRecord::Base
  self.abstract_class = true
  establish_connection "log_database_#{Rails.env}".to_sym
end

class AccessLog < LogDatabase
end

class CheckoutLog < LogDatabase
end

More Related Contents:

  1. ActiveRecord: size vs count
  2. Rails update_attributes without save?
  3. Format a string containing Phone numbers
  4. What is the easiest way to duplicate an activerecord record?
  5. Rails 3: Get Random Record
  6. How to get a query string from a URL in Rails
  7. query , can not select column count
  8. Rails 3 disabling session cookies
  9. Can we call a Controller’s method from a view (as we call from helper ideally)?
  10. How to get a Date from date_select or select_date in Rails?
  11. counter_cache with has_many :through
  12. Can I write PostgreSQL functions on Ruby on Rails?
  13. Validate uniqueness of multiple columns
  14. How can I specify a local gem in my Gemfile?
  15. What is the right way to override a setter method in Ruby on Rails?
  16. Convert HTML to word file ?
  17. How to change the default path of view files in a Rails 3 controller?
  18. Why use “self” to access ActiveRecord/Rails model properties?
  19. How to define action with simple form for?
  20. Ruby: problem installing EventMachine under Windows 7
  21. What is the difference between pluck and collect in Rails?
  22. Ruby on Rails 3 howto make ‘OR’ condition
  23. Why is Rspec saying “Failure/Error: Unable to find matching line from backtrace”?
  24. Rails catch-all/globbing routes
  25. Is there a “phpmyadmin” for Ruby on Rails? [closed]
  26. Always getting 401 Unauthorized with new install of Rails + Devise
  27. Rails 2 to Rails 3 : using link_to instead of link_to_remote (including remote and update)
  28. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  29. Ruby 1.9.2 and Rails 3 cannot open rails console
  30. Why should we avoid using class variables @@ in rails?

Leave a Comment