[Biojava-l] SQL-backed persistent Biojava sequence/feature objects

Ann Loraine loraine@loraine.net
Mon, 30 Jul 2001 04:13:54 -0700 (PDT)


I've been using postgresql a lot lately and really like it.  I hope you
will use this db system.

-Ann

---

Ann E. Loraine
http://www.loraine.net

On Mon, 30 Jul 2001, Ewan Birney wrote:

> On Mon, 30 Jul 2001, David Huen wrote:
> 
> > a) choice of DB
> > I've made a start on implementing the above and using Postgresql
> > for the purpose as it appears to be the only "free" database with
> > transactions implemented.  I figure we will want transactions as we will
> > either want the sequences/features completely instantiated or not at all.
> > 
> > There appears to be a JDBC for Postgresql.
> > 
> > Are there any strong objections to the choice or considerations I might
> > have missed?
> > 
> > The above might take some time as my SQL and JDBC are pretty much ground
> > zero.  Ach well, things can only get better...
> 
> 
> Guys - the sensible thing is to merge efforts with my Bioperl-db - not
> point have two schema's doing the same thing.
> 
> I would be more than happy to see the bioperl-db move from mysql to
> postgres or ideally be used by both.
> 
> 
> 
> 
> > 
> > b) identifier for used for retrieval
> > When recovering sequences from the DB, I'll need some identifier.  Is
> > there any reason I shouldn't use the uri field or will I need to offer an
> > alternative naming field to use for retrieval as well?
> > 
> > Regards,
> > David Huen, Dept of Generics (as an enquirer named us recently),
> > University of Cambridge
> > 
> > 
> > 
> > 
> > 
> > _______________________________________________
> > Biojava-l mailing list  -  Biojava-l@biojava.org
> > http://biojava.org/mailman/listinfo/biojava-l
> > 
> 
> -----------------------------------------------------------------
> Ewan Birney. Mobile: +44 (0)7970 151230, Work: +44 1223 494420
> <birney@ebi.ac.uk>. 
> -----------------------------------------------------------------
> 
> _______________________________________________
> Biojava-l mailing list  -  Biojava-l@biojava.org
> http://biojava.org/mailman/listinfo/biojava-l
>