[Catalyst] One App, multiple databases

[Chris Carline]

On Wed, Nov 19, 2008 at 10:53 PM, Jose Luis Martinez
<jlmartinez-lists-catalyst at capside.com> wrote:
> Basically we giving multi-tentant capability to our app (which was ported
> from some old CGIs). The CGIs where setup to load config files based on the
> REMOTE_USER, so we gave each user a separate DB just by changing the connect
> string. Now in Catayst we want the same effect ;), as sharing one database
> between all users is a step we don't want to take (for the moment).

I've achieved something similar to this by connecting to the
user-specific database where appropriate via an effective model-like
(non cat) module in the Root/auto portion of the application.

This works well-enough for my purposes, but you might want to call out
to a dedicated service if you want to achieve better persistence than
this would otherwise afford.

Chris