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

[Ewan Birney]

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>. 
-----------------------------------------------------------------