On 4/7/08, Stephen Woodbridge <[EMAIL PROTECTED]> 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@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/ _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
