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

[Yves Jacolin]

Hello Andrea,

Can't you do that by "chmod" the file?

Y.

2018-01-10 12:28 GMT+01:00 Andrea Peri <aperi2007 at gmail.com>:

> 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 àèìòù
> -----------------
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>



-- 
Training and support manager
Camptocamp France SAS
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac

Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21

email : yves.jacolin at camptocamp.com
http://www.camptocamp.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180110/718051a9/attachment.html>