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

[Meyer, Jesse R. (GSFC-618.0)[SCIENCE SYSTEMS AND APPLICATIONS INC]]

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?

Best,
Jesse

Lead Computer Scientist
Science Systems and Applications, Inc.
Dr Compton Tucker Team
NASA Goddard Space Flight Center
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20250108/da1e1c59/attachment-0001.htm>