[cgiapp] Re: [OT] Q: Configuring - Same app - Different databases

[Mark Stosberg <suppressed>]

On 2005-10-22, Ron Savage <suppressed> wrote:
> Hi Folks
>
> Which method do people use to handle the senario in the Subject:
>
> o DSN/user/pass in the environment?
> 	- If so, you do configure Apache to set the env on a per-location basis?
>
> o Ditto in config files?
> 	- If so, how do you specify which config file?

When I've created apps that can use more than one db, I used the config
file to drive it all.

At the time I rolled my own little DSN building tool. 

Today I would try DBIx::DBH with it's "connect_data()" method. 

 With it, simply defining a different values in a hash in the config
file should be sufficient.

More broadly, I never found a database abstraction technique that I was
particulary happy with. 

Now I'm more inclined to support a single database as long as possible. :)

It seems awfully hard to avoid making the application cater to the
lower-common-demoninator of functionality with a DB abstraction layer.


    Mark


---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
              http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed