On Nov 19, 9:40 am, Anthony <[EMAIL PROTECTED]> wrote: > This is not a request about how to accomplish connections to multiple > databases, etc.. > > But, I am looking for advise on the best way to start a new project. I > will have multiple clients, each will want their data protected from > the other clients. I would probably have up to about 10 tables per > client.
I'm assuming all 10 tables are actually the same for each client, right? Just have an 11th table - "clients". Relate your other tables to the clients table, and use the power of ActiveRecord to query for all the data you need for a specific client. You can use a before_filter in your application controller to look at the subdomain to discover which client you're supposed to be using. Jeff purpleworkshops.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
