in reply to Change DBI database on runtime

To me it makes more sense to have one database, with ClientID as a Primary Key in the relevant tables or parent tables. Catalyst can them map the virtual host name to the ClientID to ensure each client sees only their own data.

Replies are listed 'Best First'.
Re^2: Change DBI database on runtime
by miguelele (Beadle) on Nov 13, 2011 at 00:09 UTC

    Thanks, but all data is already structured and being used in a real php production environment, so changing the db is not an option

    Even more, each database has six tables, some of them with many thousands of records, and one table is a pair/value prefernces table (like Wordpress preferences),whith three keys, so adding another layer of relationship does not seems to be a good idea

[reply]

In Section Seekers of Perl Wisdom