[postgis-users] SQLite and postGIS

[Shoaib Burq]

You are not alone... I have been using SQLite for my web mapping
applications precisely because its so quick to get it running.

I have not had the need to do any advance spatial functions but I can
imagine it would be nice to have.

Has anyone done a preliminary check of how hard it would be to add
support for Simple Features and Spatial Indices to start with? Perhaps
its time to start. I'm going to be in the USofA 1-24 May if anyone
wants to meetup

Shoaib Burq
--
http://rails.nomad-labs.com

On Tue, Apr 8, 2008 at 8:34 AM, Stephen Woodbridge
<woodbri at swoodbridge.com> 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
>