search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
4.37k stars 549 forks source link

Add SpatiaLite plugin #3335

Open pawelsalawa opened 6 years ago

pawelsalawa commented 6 years ago

Details

Add SpatiaLite database plugin: https://www.gaia-gis.it/fossil/libspatialite/index

It will also fix the issue #3276

Saijin-Naib commented 5 years ago

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

pawelsalawa commented 5 years ago

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.

Saijin-Naib commented 5 years ago

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.

pawelsalawa commented 5 years ago

Well, probably sample data would be useful to validate foreign key handling.

Saijin-Naib commented 5 years ago

Okay, this should have everything that SpatiaLite supports that is exposed by the QGIS GUI. SpatiaLite_Sample.zip

wojtech commented 2 years ago

+1 This plugin would be really useful!

rhewy commented 1 year ago

+1

vmhacker commented 1 year ago

+1

ryanjshields commented 1 year ago

+1

WohlstadterEWG commented 7 months ago

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.