search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.63k stars 3.01k forks source link

[Browser] Display only the tables created by the user in the spatialite db #50553

Open pigreco opened 2 years ago

pigreco commented 2 years ago

Feature description

With the upgrade of SpatiaLite from 4.3 to 5.1, the Browser Panel displays all the system tables of the SpatiaLite database instead of only displaying the tables created by the user.

If I created an empty database from the Browser Panel, I would display two system tables that it would be better not to display;

image test_browser_spatialite_QGIS.zip

If you created an empty spatialite database with spatialite_gui, the browser would display many system tables and this is not functional:

image

test_browser_spatialite_gui.zip

Additional context

The ideal would be to view only the tables created by the user as happens in the view of the Connections starting from the Data Source Manager:

image

elpaso commented 2 years ago

You can't compare the two views: in the data source manager you have to check [ ] Mostra anche tabelle senza geometria