[postgis-users] SQLite and postGIS

[P Kishor]

On 4/7/08, 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?

Did you see a thread that I started on OSGeo Discuss a few months
ago... it kinda devolved into (dare I say, degenerated into) a very
long and unproductive back and forth, but my idea was a SQLiteGIS on
the lines of PostGIS.

I actually wrote a pretty useful point-in-polygon routine using Perl
DBD::SQLite unwrapping Shapefiles into a SQLite db and then using
SQLite for boundary matching. It was for a very large p-in-p (7.5
million points against 250k polys) that ArcGIS was choking over. Works
very sweet in Perl/SQLite in about 20% to 30% of the time taken.

I often wonder what would it take to graft Geos inside SQlite. Too bad
I know nothing about C++.


>
>  Thanks,
>   -Steve
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/