[QGIS-Developer] Regular vs spatialite sqlite database

[enrico chiaradia]

Thank you Sandro for your fast answer and to highlight some important 
features of spatialite.

I didn't post any code to not stress about punctual aspects as the web 
is rich of best practices about the creation and management of 
spatialite db in python. I'm quite sure to have followed the right way 
and to have obtained the best performance. I think that the delay 
recorded in the use of spatialite db is related to the dimension of the 
file respect to shapefile and sqlite, also when it is empty, and that 
could be very annoying for the end user.
If I can summarize your arguments, advantages in the use of spatialite 
respect to sqlite (shapefiles are already excluded from the match) can 
be short to this rough list:
1) geometry checking, 2) faster reading process and 3) spatial index.

I could be wrong but, geometry checking could be handled by core qgis 
and custom functions to check type and SRID (I already have to manage 
user behaviours to build a consistent db). Reading and writing process 
should have the same speed as I'm implementing an interactive tool but, 
to say the true, I didn't experience any limitation in the use of 
spatialite except for the initialization process Finally, spatial index 
feature is already implemented in qgis but I have to check if it is 
really supported also in case of sqlite db.
Supposing to maximize the use of core qgis functionality and customized 
functions, do you think that can I waive spatialite features to a most 
"simple" storage file like sqlite?

Thanks,
enrico

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170724/fa2be422/attachment.html>