[Biopython] SQL Alchemy based BioSQL

[Peter]

On Fri, Aug 21, 2009 at 10:27 AM, Peter<biopython at maubp.freeserve.co.uk> wrote:
> On Thu, Aug 20, 2009 at 10:59 PM, Kyle Ellrott<kellrott at gmail.com> wrote:
>>
>>> Ah. That ties in with the other changes on your github tree (to
>>> work nicely with Jython) which had seemed unrelated to me.
>>>
>>> I guess MySQLdb etc uses C code which means it won't
>>> work under Jython. I don't know enough about Jython to say
>>> if there are any other alternatives to using SQLAlchemy.
>>
>> If you aren't using a layer of abstraction like SQLAlchemy, they you
>> can use the standard Java SQL interfaces (JDBC).  But code written for
>> that would only work within Jython and be useless for CPython.
>
> Still, it might be worth while. Assuming it can be done as a
> (Jython specific) modular backend to the existing BioSQL
> framework, it should be a less invasive change.

Would this mean using zxJDBC (included with Jython 2.1+)?
http://wiki.python.org/jython/UserGuide#database-connectivity-in-jython
That sounds worth looking into to me.

Peter