SQLite: how to load extension Spatialite?

Answered

I downloaded Spatialite DLLs. Now I want to load this extension via

SELECT load_extension("mod_spatialite")

I get the error: [1] [SQLITE_ERROR] SQL error or missing database (%1 is not a valid Win32 application.)

Where is the place I have to put all downloaded DLLs? How to load the extension properly inside DataGrip?

Windows 10 x64, DataGrip 2017.2.2.

3 comments
Comment actions Permalink

Please, specify the full path

 

0
Comment actions Permalink

Is there any way to load extensions per default for all sqlite data sources?

0
Comment actions Permalink

Please, file an issue in our tracker, Peter:

youtrack.jetbrains.com/issues/DBE

0

Please sign in to leave a comment.