[Qgis-user] Request for quotation to fix SpatiaLite database visualization in QGIS 4 Browser Panel

[Totò Fiandaca]

Thanks for the quick response.

I'm attaching the updated code with the new table names.

Thanks to whoever updates the file.

Il giorno lun 8 set 2025 alle ore 02:06 Nyall Dawson <nyall.dawson at gmail.com>
ha scritto:

>
>
> On Sun, 7 Sept 2025 at 18:11, Totò Fiandaca via QGIS-User <
> qgis-user at lists.osgeo.org> wrote:
>
>> Dear all,
>>
>> after upgrading SpatiaLite from version 4.3 to 5.1, we noticed that the
>> QGIS Browser Panel now displays all the system tables in the database,
>> whereas previously only user-created tables were shown.
>>
>> This change makes navigation cumbersome and confusing for end users, who
>> are faced with a long list of irrelevant system tables.
>>
>> I would therefore like to ask if it is possible to receive a quotation
>> for the development of a fix that restores a cleaner behavior, showing only
>> user-relevant tables in the Browser Panel. Once the cost is defined, I will
>> personally take care of coordinating the necessary fundraising.
>>
>> I am available to provide further technical details or practical examples
>> if useful to better define the request.
>>
>> Thank you, as always, for your work on QGIS and for your attention to
>> these issues.
>>
>
> I could quote, but the fix is quite trivial -- you just need to add those
> new tables to the hardcoded list at
> https://github.com/qgis/QGIS/blob/master/src/core/qgssqliteutils.cpp#L299.
>
> Nyall
>
>
>> Best regards,
>>
>> Totò
>>
>> https://github.com/qgis/QGIS/issues/50553
>>
>>
>> --
>> *Salvatore Fiandaca*
>>
>> Questo documento, allegati inclusi, contiene informazioni di proprietà di
>> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
>> in relazione alle finalità per le quali è stato ricevuto. E' vietata
>> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
>> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
>> di informare tempestivamente il mittente e distruggere la copia in proprio
>> possesso.
>> _______________________________________________
>> QGIS-User mailing list
>> QGIS-User at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>> --
>> *Salvatore Fiandaca*
>>
>> Questo documento, allegati inclusi, contiene informazioni di proprietà di
>> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
>> in relazione alle finalità per le quali è stato ricevuto. E' vietata
>> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
>> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
>> di informare tempestivamente il mittente e distruggere la copia in proprio
>> possesso.
>>
>>
>>
>>
>> <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>
> <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>
<https://lists.osgeo.org/mailman/listinfo/qgis-user>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250908/2ac04eef/attachment.htm>
-------------- next part --------------
QStringList QgsSqliteUtils::systemTables()
{
  return QStringList() << QStringLiteral( "SpatialIndex" ) << QStringLiteral( "geom_cols_ref_sys" ) << QStringLiteral( "geometry_columns" )
         << QStringLiteral( "geometry_columns_auth" ) << QStringLiteral( "views_geometry_columns" ) << QStringLiteral( "virts_geometry_columns" )
         << QStringLiteral( "spatial_ref_sys" ) << QStringLiteral( "spatial_ref_sys_all" ) << QStringLiteral( "spatial_ref_sys_aux" )
         << QStringLiteral( "sqlite_sequence" ) << QStringLiteral( "tableprefix_metadata" ) << QStringLiteral( "tableprefix_rasters" )
         << QStringLiteral( "layer_params" ) << QStringLiteral( "layer_statistics" ) << QStringLiteral( "layer_sub_classes" )
         << QStringLiteral( "layer_table_layout" ) << QStringLiteral( "pattern_bitmaps" ) << QStringLiteral( "symbol_bitmaps" )
         << QStringLiteral( "project_defs" ) << QStringLiteral( "raster_pyramids" ) << QStringLiteral( "sqlite_stat1" ) << QStringLiteral( "sqlite_stat2" )
         << QStringLiteral( "spatialite_history" ) << QStringLiteral( "geometry_columns_field_infos" ) << QStringLiteral( "geometry_columns_statistics" )
         << QStringLiteral( "geometry_columns_time" ) << QStringLiteral( "sql_statements_log" ) << QStringLiteral( "vector_layers" )
         << QStringLiteral( "vector_layers_auth" ) << QStringLiteral( "vector_layers_field_infos" ) << QStringLiteral( "vector_layers_statistics" )
         << QStringLiteral( "views_geometry_columns_auth" ) << QStringLiteral( "views_geometry_columns_field_infos" )
         << QStringLiteral( "views_geometry_columns_statistics" ) << QStringLiteral( "virts_geometry_columns_auth" )
         << QStringLiteral( "virts_geometry_columns_field_infos" ) << QStringLiteral( "virts_geometry_columns_statistics" )
         << QStringLiteral( "virts_layer_statistics" ) << QStringLiteral( "views_layer_statistics" )
         << QStringLiteral( "ElementaryGeometries" )
         // Additional tables to hide in the browser panel
         << QStringLiteral( "all_buckets_objects" ) << QStringLiteral( "data_licenses" ) << QStringLiteral( "iso_metadata" )
         << QStringLiteral( "ISO_metadata_reference" ) << QStringLiteral( "ISO_metadata_view" ) << QStringLiteral( "KMN2" )
         << QStringLiteral( "networks" ) << QStringLiteral( "raster_coverages" ) << QStringLiteral( "raster_coverages_keyword" )
         << QStringLiteral( "raster_coverages_ref_sys" ) << QStringLiteral( "raster_coverages_srid" ) << QStringLiteral( "SE_external_graphics" )
         << QStringLiteral( "SE_external_graphics_view" ) << QStringLiteral( "SE_fonts" ) << QStringLiteral( "SE_fonts_view" )
         << QStringLiteral( "SE_raster_styled_layers" ) << QStringLiteral( "SE_raster_styled_layers_view" ) << QStringLiteral( "SE_raster_styles" )
         << QStringLiteral( "SE_raster_styles_view" ) << QStringLiteral( "SE_vector_styled_layers" ) << QStringLiteral( "SE_vector_styled_layers_view" )
         << QStringLiteral( "SE_vector_styles" ) << QStringLiteral( "SE_vector_styles_view" ) << QStringLiteral( "stored_procedures" )
         << QStringLiteral( "stored_variables" ) << QStringLiteral( "topologies" ) << QStringLiteral( "vector_coverages" )
         << QStringLiteral( "vector_coverages_keyword" ) << QStringLiteral( "vector_coverages_ref_sys" ) << QStringLiteral( "vector_coverages_srid" )
         << QStringLiteral( "wms_getmap" ) << QStringLiteral( "wms_ref_sys" ) << QStringLiteral( "wms_settings" );
}