[BioSQL-l] case sensitivity in biosql accessions under BioJavax/Hibernate

[Hilmar Lapp]

On Dec 4, 2008, at 7:19 AM, James Procter wrote:

> In a situation where the backend DB is case sensitive, new accessions
> inserted into the DB must be forced to be the same case in the same  
> way
> as the accession query string will be forced to be.

I would advise against this if you are interested in cross-Bio*  
interoperability at all. As I pointed out previously, such  
transformations need not be permanent but can be done on-the-fly.

> This modification is again straightforward, but the case change  
> would also have to be propagated to existing entries in the BioSQL.  
> Furthermore, modifying the
> Biojava-x bindings would only ensure case-insensitivity for Biojava
> queries, the same modification would also be necessary for the other
> bio-* bindings.


Right, and I'm not sure that's a good rule to impose on all  
implementations.

	-hilmar
-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:-  hlapp at gmx dot net :
===========================================================