I asked on another thread about adding an "organisation_id" across the
whole database to effectively give a separate database for different
organisations who use the app.
The other way of doing it would be to have one app but different
databases depending on the subdomain (or some logon credential).
I'm not really sure how to do this.. probably something like:
:adapter => mysql,
:host => localhost,
:username => xyz,
:password => password,
:database => "Different for each subdomain"
in the application.rb but I'm a bit unsure of the details.
Not sure if there would be a lot of extra grief running migrations etc
with multiple databases...
Any ideas of pros and cons and recommended solutions welcome.
The app is mysql running on apache /passenger.