QGIS Browser - gpkg "refresh"

[wburt]

Feature description. Functionality for right click on a Geopackage in QGIS browser is:

• Remove Connection
• Create a New Layer or Table
• Delete
• Compact

When additional layers are added to the prepackage via QGIS processing tools or saving data from the layer panel the need to refresh the Geopackage contents may arise. This isn't currently obvious but can be achieved via removing your gpkg connection and adding it again. I propose a Refresh option be added to the gpkg provider (perhaps consider other similar providers fgdb,spatialite, etc).

[stev-0]

I have been bitten by this before, good idea

[elpaso]

What are the UX "visible" issues involved here? Are you thinking at the layers shown in the browser tree? Any other part of the GUI involved?

I'm asking because at least for the browser we do already have refresh functionality implemented, perhaps it's just not triggered in your workflow.

In any event one or more step-by-step procedures to reproduce the issues would be very useful.

[wburt]

I think there is a few situations where this would be a convenience for more provider types than just gpkg. Here is the gpkg example:

1. Fire up QGIS with new project
2. Create a geopackage layer from the Data Source Manager toolbar for an existing gpkg, new layer -->geometry (polygon)
3. Use the processing tool Random Points in Polygon, uncheck open output file after running algorithm

At this stage your new geopackage layer and new points are not visible in the browser. It would be a nice to have to be able to right click on the gpkg within the browser and select a refresh event. This refresh feature would also be nice to have for folders in the case of the above workflow if you created a new gpkg in step 2. Then you could click refresh on the destination folder to see your new gpkg.

Hopefully that makes sense and I am not missing something obvious. Any feedback is welcome.

[wburt]

Slightly annoying that when you remove your geopackage connection and add it again my database connection refreshes its contents catalogue.

[BenGunnewijk]

I would also like to see a refresh option.

In my case I have QGIS and another application open, the other application adds a layer to or removes a layer from the geopackage and the QGIS browser panel does not show the change nor does it allow me to manually refresh the package or individual layers.

Indeed the browser does refresh the geopackage when either adding or removing the geopackage database connection.

[github-actions[bot]]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale". If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue. In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue. If there is no further activity on this issue, it will be closed in a week.

[maphew]

Yes please. Removing and re-adding a database connection in order see the new gpkg contents is error prone at worst and tedious at best when there are a number folders to navigate.

Update: smoothest interim refresh method I've come across is to drag and drop the .gpk file from a file manager onto the Qgis window.