Hello,
I am investigating whether DBIC has support for switching between
logical databases (ala 'use db1; ...; use db2; ...;'). I've a situation
where there exist many cloned databases (same DDL), one per customer.
The current model is that all customers share the same front-end, and it
switches between DBs as needed. I would like to avoid the following:
multiple open connections per app process, multiple MyDB::Schema
objects, server hups upon customer adds/drops, etc.
The very reasonable suggestion to combine all of the client databases
into one is being considered, so please let's not get side-tracked by
that line of thought, thanks. :)
So... how might I have my Schema issue a 'use $db' prior to any queries?
Or perhaps are there other solutions to how one could have multiple DB
clones while avoiding the code and connection scaling issues?
Thanks,
--Trevor
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
