I am developing a sort of CMS application that will be used by
multiple domains on my host.
Each domain requires its own set of users, news, etc., but I would
like to keep my application only installed one place on my host and
sym-link to it.
Is it possible to modify all queries to also include a 'domain' in the
where clause or something like that?
i.e. if i do a Table.find(:all) in one of my controllers, and that
controller is being accessed by domain1, can I limit the query's
results by some sort of where clause?
I dabbled with the idea of using table prefix's, but later ditched the
It seems like the appropriate solution is to add another column to my
tables that includes which domain the data is specific to and somehow
limit that in the application... any ideas?