in reply to I swim in a sea of databases and DBIx::Connect is barely adequate

I really can't see this as an important issue. And frankly, I would copy the username and password seven times. Because I would treat the fact that the username and passwords are the same as a coincidence. If the usernames and passwords were different (which, if I were the database admin, they would), you had to write down seven usernames and passwords anyway.

I've been a database administrator, and I had to deal with over 20 database servers with hundreds of databases, with new servers popping up and old ones disappearing all the time. All configuration information I needed for my admin scripts was kept in a single Perl datastructure (a nested hash), and used whenever needed. Adding an entry for a new server or database was a matter of less than a minute (just copy a subhash, change the values), so even if you had a couple of new servers a day, you still didn't need to spend a lot of time updating the configuration.

Abigail

  • Comment on Re: I swim in a sea of databases and DBIx::Connect is barely adequate
  • Download Code