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 - [EMAIL PROTECTED] > http://biojava.org/mailman/listinfo/biojava-l > ----------------------------------------------------------------- Ewan Birney. Mobile: +44 (0)7970 151230, Work: +44 1223 494420 <[EMAIL PROTECTED]>. ----------------------------------------------------------------- _______________________________________________ Biojava-l mailing list - [EMAIL PROTECTED] http://biojava.org/mailman/listinfo/biojava-l