Thanks Mikel, The view idea worked great with MySql. I didn't even know about views until you mentioned it.
Ivan On Oct 27, 9:08 am, "Mikel Lindsaar" <[EMAIL PROTECTED]> wrote: > On Fri, Oct 24, 2008 at 4:53 PM, Ivan Vanderbyl <[EMAIL PROTECTED]> wrote: > > I have a scenario, we have 2 applications running on the same server, > > each on their own domain, (but that's irrelevant), both applications > > have a User model (and table, in separate databases), both use Restful > > auth plugin etc. > > I have set app B to load users from the database of app A with a > > custom connection in the User model, all works smashingly! What I'm > > wondering is, lets say I wanted all users to be in a separate > > database, maybe on another server, which only stores users, is there > > some; possibly undocumented way of telling ActiveRecord::Migration to > > connect to another database when running that migration? > > > Also, I haven't tried this, but maybe someone has, or knows someone > > else who has: Will my record associations still work? e.g. User > > has_many Orders? or User HABTM Roles if the roles table is on another > > database? > > I have a similar situation, but not with a users model. > > The way I handled this is using PostgreSQL and multiple schemas, then > one application owns the table, and the other just has a view of it. > This way you keep your DB implementation of this solution transparent > to Rails (Rails will treat a view called 'users' just like a table > called 'users'. > > So your DB would look like this: > > ProductionDatabase > Schemas > App1 > Views > Users (select * from app2.users) > App2 > Tables > Users > > Now to make that work, you would need on insert and on delete and on > update rules on your users view obviously. > > The other (and probably) more rails way to do it would be to set up a > third authentication application and expose the users table with > ActiveResource. That way you could then plug as many apps into it as > you want. > > The third way I would look into is setting up an LDAP server and > authenticating from both apps against that. > > Anyway, hope that helps. > > --http://lindsaar.net/ > Rails, RSpec and Life blog.... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en -~----------~----~----~----~------~----~------~--~---
