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: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Sebastian E. Ovide Sent: Thursday, October 21, 2010 5:35 PM To: ni...@maich.gr Cc: mapserver-users@lists.osgeo.org 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, <ni...@maich.gr<mailto:ni...@maich.gr>> 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 mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Sebastian E. Ovide
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users