[QGIS-Developer] Two Spatialite providers in QGIS. Remove one of them?

[Tobias Schula]

Hi list,

I'm currently running into all kinds of weird problems while working 
with Spatialite-databases. For example:
 > https://github.com/qgis/QGIS/issues/66329

I haven't even written down yet the issues I'm facing with foreign key 
constraints and triggers. Because I found already a solution: Don't use 
the Spatialite provider, but OGR. It will respect foreign key 
constraints and even load them while adding the layers. It also 
automatically sets up the autogenerate form with appropriate input 
fields like "range" for `INTEGER` and "text" for `NUMERIC`/`REAL`.

There are also other problems with the Spatialite data provider, that 
don't occur when using GDAL/OGR:
 > https://github.com/qgis/QGIS/issues/48390

Is there a reason QGIS is still carrying the Spatialite provider? Can it 
be fully replaced with OGR? OGR is coming with Spatialite support ootb 
anyway, why would QGIS bring two implementations?

Thus, I'd propose to remove the Spatialite provider, since OGR is 
offering a more mature solution and removing a different implementation 
with overlapping functionality would reduce the maintenance burden on 
you developers.


Best regards

-- 
Tobias A Schula
Forestry Expert

geospatial at schula.org

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0x3B6BA2B3E91776FA.asc
Type: application/pgp-keys
Size: 3126 bytes
Desc: OpenPGP public key
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20260623/13c02222/attachment-0001.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 840 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20260623/13c02222/attachment-0001.sig>