P Kishor wrote:
On 4/11/08, Richard Greenwood <[EMAIL PROTECTED]> wrote:
Are any of you driving a MapServer layer with Sqlite, and if so, would
you provide an example layer definition? I could sure see a lot of
utility in a spatial database that was somewhere between shapefiles
and PostGIS.
as far as I know, it doesn't exist *yet*. I am pretty confident that
we shall see this ability sooner rather than later (a hunch,
nonetheless, a confident hunch).
Puneet, Rich,
SQLite is already supported as a spatial database by OGR. The caveat
is that in GDAL 1.5 it is just using a text column with WKT geometries so
the spatial performance is not great.
To use this with MapServer you would use CONNECTIONTYPE OGR and the
CONNECTION string would be the path for the sqlite database. The
DATA statement should hold the table name be accessed.
There is some work going on to support SQLite in a more sophisticated
way.
SQLite is by no means a PostGIS replacement, but it can be a useful
as a single-file, multi-table spatial data format with SQL support.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGeo, http://osgeo.org
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
