[QGIS-Developer] GeoPackage - where are we -where do we go

[Ismail Sunni]

Hi Tobias,

VACUUM doesn't help here and isn't reachable easily using a button in
> QGIS. Seems like there's much empty space in the db scheme. Perhaps
> anyone can explain this?


You can right-click on the gpkg file in the file browser panel and you can
see the `Compact Database (VACUUM)`.

Best regards

On Fri, May 8, 2020 at 1:52 PM Tobias Wendorff <
tobias.wendorff at tu-dortmund.de> wrote:

> Am 08.05.2020 um 11:30 schrieb Matthias Kuhn:
> >
> > I do not want to trigger a evangelical discussion here. I'd like to see
> > where we are and what we can reasonably do to have a default file format
> > which can be recommended with no bad feelings.
>
> Two downsides of GPKG, which I've experienced with many users, who
> worked with Shapefiles in the past:
>
> 1. A GPKG can contain multiple layers, but has one filename only. This
> confuses many users. They're expecting single files, like
> "houses_poly.gpkg" and "houses_point.gpkg". When they only see
> "houses.gpkg", they think they're missing anything. From the normal
> Windows Explorer (don't know about Nautilus etc.), you also cannot watch
> inside the GPKG file to check its content. It would be nice to make
> Windows parse GPKG's/sqlite3's metadata.
>
> 2. As pointed out in the past, a big downside of GPKG or sqlite3 is the
> huge bloat. I often have single table GPKGs, which are 12 GiB. When
> compressing them with zstd, I can get it down to 3 GiB or even less in
> about no time.
>
> VACUUM doesn't help here and isn't reachable easily using a button in
> QGIS. Seems like there's much empty space in the db scheme. Perhaps
> anyone can explain this?
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
Ismail Sunni
Software Engineer
ismailsunni.id
ismailsunni.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200508/40106a52/attachment.html>