sqlitestudio
sqlitestudio copied to clipboard
pawelsalawa
Add SpatiaLite plugin
Details
Add SpatiaLite database plugin: https://www.gaia-gis.it/fossil/libspatialite/index
It will also fix the issue #3276
Is this still in development? I have much the same issue as the user for #3276 as no tool I can find (Spatialite-GUI, QGIS, SQLiteStudio, etc) can properly handle renaming data tables without all the triggers, indexes, etc, breaking horribly.
Do you want a completely vanilla spatialite database containing just one empty vector geometry layer with indexes/etc? blank.zip
Thanks for the sample. It will definitely help with the implementation.
Yes, project is still under development, although I have intensive periods of development (like last 2 releases) and then a significant period of pause, due to personal reasons.
Project is very much alive.
Do you want/need samples with actual geometry that have spatial indices and attribute indices, or do you not need that for implementation?
I wonder if SQLiteStudio could replace the Database Manager GUI in QGIS...
Not a problem at all! I was just curious to see if Spatialite was still something you were interested in or not. To be frank, I'm a little surprised that dedicated tools don't even support renaming properly. It must be a huge pain in the rear to implement.
Well, probably sample data would be useful to validate foreign key handling.
Okay, this should have everything that SpatiaLite supports that is exposed by the QGIS GUI. SpatiaLite_Sample.zip
I have been able to get SpatiaLite working with version 4 (e.g. mod_spatialite-4.3.0a-win-amd64). Place the dlls in a directory in the Windows path (or add the directory to the Windows path) and copy mod_spatialiate.dll into one of the SQLite Studio extension directories (e.g. SalSoft\SQLiteStudio\ext).
I have not been able to get SpatiaLite 5.x to work.
