[BioSQL-l] SQLite support

[Chris Fields]

Should be easy enough to add this in to the main repo.  The best way to check it is via the various language-specific adaptors for BioSQL (bioperl-db, etc).  

Peter, do you want the honors, or should I go ahead?

chris

On Oct 29, 2010, at 11:41 AM, Christopher Bottoms wrote:

> Peter, Hilmar, Chris, Brad, and others,
> 
> At BOSC, I modified a version from biopython, resulting in the
> attached file. I did this for Hilmar and he is welcome to do whatever
> he wants with it. I regretted not having anything to test it against,
> but it did create the SQLite tables without emitting errors or
> warnings.
> 
> Thanks Hilmar for providing this opportunity! I learned more about
> SQLite in two days than I had the previous two years.
> 
> Sincerely,
> Christopher
> 
> 
> On Thu, Oct 28, 2010 at 11:54 AM, Peter <biopython at maubp.freeserve.co.uk> wrote:
>> On Tue, Jul 20, 2010 at 10:50 PM, Hilmar Lapp <hlapp at gmx.net> wrote:
>>> 
>>> 
>>> On Jul 20, 2010, at 4:12 PM, Peter wrote:
>>> 
>>>> Did you guys manage to sit down together to look at the BioSQL
>>>> on SQLite3 schema during BOSC/ISMB?
>>> 
>>> 
>>> Yes. I not os much, sadly, but I was lucky enough that one of the
>>> participants, Chris Bottoms, volunteered to take on that task, and I believe
>>> more or less completed it. I'm indebted to you, Chris!
>>> 
>>> I don't think he has svn write access, so if I'm not mistaken it's not
>>> committed yet. Rather than bothering with getting him an account on the
>>> open-bio machine, Chris Fields and I were going to migrate BioSQL over to
>>> github this week, and then we can go from there.
>>> 
>>>        -hilmar
>> 
>> Hi Hilmar,
>> 
>> BioSQL moved over to github successfully, does that me Brad (or I)
>> have your blessing to checkin the proposed SQLite schema as is?
>> Or are there some tweaks from BOSC/ISMB?
>> 
>> Thanks,
>> 
>> Peter
>> 
> <biosqldb-sqlite-July2010.sql>