I looks like with gdal 1.7, spatialite support has improved. If you need to support layers based on queries that link geometry tables with attribute tables, spatialite could still potentially work. I haven't tested out a spatialite layer yet though.
http://www.gdal.org/ogr/drv_sqlite.html there is also a new QGIS plugin that allows you to check data out of a PostGIS db and put it into a spatialite db. It looks like it requires the trunk version of QGIS. http://www.sourcepole.com/2010/9/29/offline-editing-plugin-for-qgis David. From: [email protected] [mailto:[email protected]] On Behalf Of Sebastian E. Ovide Sent: Thursday, October 21, 2010 5:35 PM To: [email protected] Cc: [email protected] Subject: Re: [mapserver-users] postgis to spatile-ogr if you need only to display geometries with mapserver u can simply use shapes files... anything that can be read by gdal can be read by mapserver On Thu, Oct 21, 2010 at 2:38 PM, <[email protected]<mailto:[email protected]>> wrote: Hello, Was wondering if an application that is currently set up with postgis data sources can work directly by changing only the data source, e.g change the DATA string to "ogr" in the mapfile. Have to setup a demo remotely and don't really want to drag pgsql along only for the demo. If, so, would ogr2ogr be the most direct way to dump the postgis tables into sqlite? regards, nicolas boretos _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Sebastian E. Ovide
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
