Has anybody used SQLite for spatial storage?

Topics: Data Access
Jul 10, 2008 at 1:21 PM
Edited Jul 10, 2008 at 1:21 PM
I was thinking about moving from Shapefiles to SQLite for a number of reasons but I have numerous questions.

How is it's performance vs. Shapefile? 
What fields have you indexed?
Does it support a spatial index?
and many others but these are the most important.

Jul 11, 2008 at 3:32 PM
There is a SQLLite provider provided by Bill Dollins you can explore here: http://www.codeplex.com/SharpMap/Wiki/View.aspx?title=SqlLite&referringTitle=Extensions.

SQLLite doesn't have a built in spatial index, but you can use what's in SharpMap.
Jul 14, 2008 at 12:52 PM