[mapserver-users] How use ogr provider with spatialite "read only" clause

[Andrea Peri]

Hi,
Usually we use the spatialite db as ordinary datasource for ours mapserver
wms.

Now I discovered that the last versions of spatialite always test
automatically the version of the DB sqlite and if verify that the db was
create using an older spatialite version.

TRY TO UPDATE the spatialite system tables WHEN the connection was closed.

This probably is a good strategy for an ordinary desktop application.
But more risk pendent when used on a mpaserver that could have more than
one connection open on the same DB sqlite.

To avoid this the standard solution used from the spatialite driver is to
check if the DB is open in READ-ONLY mode.

And avoid to write and update the db when it is in read-only mode.

So my trouble now is how the change the usual connection string in the
mapfile to say to the OGR driver to open the sqlite/spatialite using the
"read-only" mode.

Is this possible ?

Many thx

A.

-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180110/32d55263/attachment.html>