Re: Dynamically change data source of models

2009-08-13 Thread CobaltShark
I use Ad-hoc joins to LEFT JOIN data from different databases using the same default db config and it works well. Just specify table => 'common_db_name.table_name' . You will obviously need to ensure that the db user specified in your config has at least SELECT privs to both databases. I usually g

Dynamically change data source of models

2009-08-13 Thread Fritsie
Hello, I'm developing an application which will be used by multiple companies and I want to use a shared database for common information like users, companies, permissions etc, but I want to use a separate database for each company for their own (private) information. The reason to give every comp