[gdal-dev] Spatialite and UPDATE triggers

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Mon Nov 10 01:10:56 PST 2014


I noticed that you have worked with INSERT triggers in

What would you say about the discussion in

I suppose that the new generation triggers will be created automatically if
GDAL is built with the next-to-come Spatialite 4.2.1 but it may take some
time before majority of GDAL users will have it. However, new triggers
should be backward compatible for all Spatialite 4.x versions. I wonder if
it would make sense to make GDAL to do something similar than SELECT
UpgradeGeometryTriggers that is mentioned in the thread. Ten times more
speed when doing UPDATE of non-geometry attributes for each row is quite a
lot. Of coarse if Spatialite v. >=4.2.1 will be soon a standard for building
GDAL with Spatialite the unnecessary slow update trigger issue will be
solved automatically.

-Jukka Rahkonen-

More information about the gdal-dev mailing list