[rt-devel] DBI information

[Tobias Brox]

> MY question is, how abstract is the RT DBI code itself?  I was looking at
> the files in lib/rt/database,

The lib/rt/database stuff is to be removed in 2.0, the new code is in
Jesses DBIx modules.

> and while it's close to being able to work
> with these DBs, there is one real important thing missing off the bat.
> Schema.

MySQL sets the default "database" (which, AFAIK, is similar to schema)
during the login.  I don't think it will break MySQL if the sql sentences
are modified to use dbname.tablename instead of tablename.

> 	MySQL doesn't require the schema to be in there (As a matter of
> fact, I think it all falles under a 'mysql.' schema)

The mysql database/schema is only for database metadata (tables,
permissions, etc)

I think the most complete library for "easy" database manipulation is 
DBIx::Recordset.  It's working for any known DBMS AFAIK.  It really scares
me, because the code is huuuge.  I think it really needs to be done a lot
of work to EasySearch if it's to be nearly as good as Recordset.  Still, I
clearly see that it's room for EasySearch at CPAN.

-- 
Tobias Brox 
aka TobiX
+47 22 925 871