[postgis-users] SQLite and postGIS

[Stephen Woodbridge]

William,

Thanks for the pointer. I will check it out.
Doesn't look like they have spatial indexes, but it does look like an 
interesting start.

-Steve

William Kyngesburye wrote:
> Someone started something already.  Basic for now - good for exchanging 
> geodata.
> 
> http://www.gaia-gis.it/spatialite/
> 
> On Apr 7, 2008, at 5:34 PM, Stephen Woodbridge wrote:
> 
>> Hi Paul,
>>
>> I have started using SQLite for some projects, mostly just as a 
>> backing store for manipulating some data. I can't help but think it 
>> would be cool if it would be possible to get something like postGIS 
>> running in it.
>>
>> I know you guys did some analysis of various databases a while back 
>> with an eye to their spatial potential and suitability for postGIS 
>> like inclusion - well at least that was my impression.
>>
>> Did you look at SQLite?
>> Have you worked with SQLite?
>> Got any thoughts on this? Anyone?
>>
>> I wish I could say I had a client interested in funding, but <sigh> I 
>> don't. But I have found myself googling for info on it 4 separate 
>> times in the past week, which is strange because I have no immediate use.
>>
>> The use case for something like this would be to build a standalone 
>> application or web service that has a SQL/Spatial back-end without the 
>> need for installing and administering a postgres database.
>>
>> As best as I can tell, the major hurdle would be whether or not it is 
>> possible for a reasonable amount of effort to integrate a spatial 
>> index system into SQLite.
>>
>> Anyway, thought I would ask? See what other people thought?
>>
>> Thanks,
>>  -Steve
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> -----
> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> http://www.kyngchaos.com/
> 
> "Oh, look, I seem to have fallen down a deep, dark hole.  Now what does 
> that remind me of?  Ah, yes - life."
> 
> - Marvin
> 
>