[gdal-dev] Dropping GeoPackage table doesn't reduce file size

[Kyle Shannon]

Jerome,

On Mon, Oct 31, 2016 at 8:14 AM, jguelat <Jerome.Guelat at vogelwarte.ch> wrote:
> Thanks for you help! I thought this was done automatically...

It is disabled by default:

https://www.sqlite.org/pragma.html#pragma_auto_vacuum

If you want to enable it through OGR, you can use OGR_SQLITE_PRAGMA:

"""

Starting with OGR 1.11, any SQLite pragma can be specified with the
OGR_SQLITE_PRAGMA configuration option. The syntax is
OGR_SQLITE_PRAGMA =
"pragma_name=pragma_value[,pragma_name2=pragma_value2]*".

"""

from the SQLite driver page:

http://gdal.org/drv_sqlite.html

>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Dropping-GeoPackage-table-doesn-t-reduce-file-size-tp5293603p5293618.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
Kyle