[ic] Connecting to undefined db

[Mike Heins]

Quoting interch (interch@client.paymentonline.com):
> 
> We have an IC installation we use to manage a lot of our account setups.
> Part of the process is creating and inserting some default data into
> databases that are created for the client.  Each client has their own
> database, so defining the databases in IC before hand isn't possible.  Is
> there any trick to be able to connect to an arbitrary database not defined
> in IC without having to create a usertag to get around Safe.pm?  Any hints
> on the simplest way to do this would be appreciated.  I'd like to use the
> flex editor for this but that doesn't seem possible from what I can tell.

Using the flex editor would not be possible, except where I mention below.

The other should be. You could create a Global UserTag which passes
back a handle to the $dbh (DBI object), then do object methods with
it.

Also, you probably don't know it is possible (actually probably nobody
but me knows) to add a single database to an Interchange catalog without
going through the entire config process. Depending on how your server is
set up, it would be quite efficient and could be done on a running
server withoug impacting performance hardly at all. This would allow the
flex editor to operate on the table.

Interchange actually can easily define several hundred of its
DBs with very little downside in processing time. Benchmarks of
its dummy database creation show the ability to create about 
100,000 per second, which means that a thousand would take 
only a 10 milliseconds or so.

Implementing this is the type of thing our consulting arm can
do; they have access to me and I would help them get you going.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

If you think nobody cares if you're alive, try missing a couple of
car payments.  -- Earl Wilson