[DAS] LDAS and other databases

Lincoln Stein lstein@cshl.org
Fri, 1 Nov 2002 10:48:47 -0500


There are some small differences between the mysql ddl and oracle, and these 
are handled by Shuly's Bio::DB::GFF::Adaptor::oracleopt adaptor.

Lincoln

On Thursday 31 October 2002 04:08 pm, Tony Cox wrote:
> Hi Kevin,
>
> If you have the DBD::oracle DBI driver module available from your perl
> installation it should be very simple to change the driver specification as
> detailed below. I assume that Lincoln checked the schema for the LDAS
> database and made it "neutral" with respect to the various language
> restrictions on different DBs.....
>
> Tony
>
> > Hi,
> > There is an Oracle adaptor available.
> > PostgreSQL adaptor is under developement at the moment, and soon will be
> > available too.
> > dbi::mysql is the default, but, you can indicate that you want to use
> > dbi::oracleopt in order to work with Oracle.
> >
> > Let me know if you need further instructions.
> > Shuly.
> >
> > On Thu, 31 Oct 2002, Kevin Murphy wrote:
> > > How dependent is LDAS on MySQL?  Looking at the notes on bioperl.org
> > > about Bio::DB::GFF and bioperl-db, I don't see much indication of
> > > database-independence.  How much effort would be required to port LDAS
> > > and/or Bio::DB to Oracle or PostgreSQL?  And would this be a good
> > > thing?
> > >
> > > Thanks,
> > > Kevin
> > >
> > > _______________________________________________
> > > DAS mailing list
> > > DAS@biodas.org
> > > http://biodas.org/mailman/listinfo/das
> >
> > _______________________________________________
> > DAS mailing list
> > DAS@biodas.org
> > http://biodas.org/mailman/listinfo/das
>
> _______________________________________________
> DAS mailing list
> DAS@biodas.org
> http://biodas.org/mailman/listinfo/das

-- 
========================================================================
Lincoln D. Stein                           Cold Spring Harbor Laboratory
lstein@cshl.org			                  Cold Spring Harbor, NY
========================================================================