SpatialLite

[vrasko]

Is there some possibility to itegrate spatial lite extension in SliteStudio. I tried to add mod_spatiallite.dll, but it doesn't work.

I need some script like

cmd.CommandText = @"
CREATE TABLE test (id INTEGER PRIMARY KEY);
SELECT AddGeometryColumn('test', 'geom', 4326, 'POINT', 'XY');
INSERT INTO test (geom) VALUES (GeomFromText('POINT(14 50)', 4326));

[pawelsalawa]

What is the mod_spatiallite.dll file? Where did you get it from?

[vrasko]

Hello, SpatialLite is opensource library for extending SqLite core to work with spatial data. Home page: SpatiaLite: SpatiaLite<https://www.gaia-gis.it/fossil/libspatialite/index> other source info: SpatiaLite - Wikipedia<https://en.wikipedia.org/wiki/SpatiaLite> MS Windows binaries you can find on The Gaia-SINS federated project home-page<https://www.gaia-gis.it/gaia-sins/>, then https://www.gaia-gis.it/gaia-sins/windows-bin-amd64/mod_spatialite-5.1.0-win-amd64.7z . There is extension with depedencies. I tried to add it to SqliteStudio, which is my favorite Sqlite Db manager, but it doesn't work. I created folder SptialLite in my PC, unpacked the extension files there, set enviromwent variable Path to the folder. Then I used both Extension manager and SQL ( SELECT load_extension('c:/Progs/SpatialLite/mod_spatialite.dll'); ) but without success. It would be very nice to have possibility manage DB with spatial columns in SqliteStudio. Have a nice day. V. SpatiaLite: SpatiaLite<https://www.gaia-gis.it/fossil/libspatialite/index> SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities. SQLite is intrinsically simple and lightweight: a single lightweight library implementing the full SQL engine; standard SQL implementation: almost complete SQL-92 www.gaia-gis.it

…

________________________________ Od: Paweł Salawa ***@***.***> Odoslané: piatok 20. júna 2025 8:18 Komu: pawelsalawa/sqlitestudio ***@***.***> Kópia: Vlado ***@***.***>; Author ***@***.***> Predmet: Re: [pawelsalawa/sqlitestudio] SpatialLite (Issue #5331) [https://avatars.githubusercontent.com/u/481846?s=20&v=4]pawelsalawa left a comment (pawelsalawa/sqlitestudio#5331)<#5331 (comment)> What is the mod_spatiallite.dll file? Where did you get it from? — Reply to this email directly, view it on GitHub<#5331 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHZTR3YPU3KYEFXXS62HUIT3EORT3AVCNFSM6AAAAAB7UDBVGOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDSOBZHEYTSNBYGE>. You are receiving this because you authored the thread.

[pawelsalawa]

I tried to add mod_spatiallite.dll, but it doesn't work

What do you mean by that? If you mean just copying file into SQLiteStudio folder and not doing anything else - it's not enough. You need to load it, either through SELECT load_extension('path_to_ddl_file'); or through Extension Manager (a button with a brick icon available on the toolbar).

I was able to load the extension successfully.

[vrasko]

I wrote: I created folder SptialLite in my PC, unpacked the extension files there, set enviromwent variable Path to the folder. Then I used both Extension manager and SQL ( SELECT load_extension('c:/Progs/SpatialLite/mod_spatialite.dll'); ) but without success.
From Extension manager:

From SQL command: