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

Reply via email to