What I am trying to do is to connect to a database dynamically with rails based on what the user puts in on the web page, I am new to ruby and not sure how to do this, I want support for any common databases but doing it with active record requires you to have the actual database and that is not good, I want to be able to connect to any database without actually having it on my server.
Any ideas?
Cheers, Andrei
You can change the database connection that you want to use by calling establish_connection at some point during the flow
ActiveRecord::Base.establish_connection(
:adapter => 'mysql',
:host => 'localhost',
:username => 'name',
:password => 'password',
:database => 'db_name'
)
You should even be able to do this in a before filter, if that is what you need to do, or call establish_connection on individual models so that they use a different database.
