[gdal-dev] ExecuteSQL method to dependably remove features from datasource

[Even Rouault]

Jesse,

> I seem to be able to remove features from a GPKG datasource using 
> ExecuteSQL and “delete from layer_name where cond” style query with 
> the SQLITE dialect.  For some of our use cases, this is quite a bit 
> nicer than a manual loop in Python.
>
> Are there restrictions or other concerns that I should keep in mind 
> when using this, beyond the recommendation to VACUUM afterwards to 
> shrink the disk file down?
>
That is perfectly fine. There are triggers to update the spatial index 
and the feature count.

Even

-- 
http://www.spatialys.com
My software is free, but my time generally not.
Butcher of all kinds of standards, open or closed formats. At the end, this is just about bytes.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20250108/77bf4e70/attachment.htm>