[Qgis-user] DB Browser connection via Spatialite

[Walt Ludwick]

Excited to learn via this excellent tutorial [1] that i can connect my
favorite SQL tool (DB Browser for SQLite) to the .gpkg files that i am just
starting to build w/ QGIS, i gave it a try straight away and found that it
does indeed recognize my .gpkg file as a readable database, such that i can
explore the db structure and browse tables data -- Except for the "geom"
column, which just has "blob" in every field (first clue it's not so
simple!).

Then i tried to make a small edit to one field of non-geographic data...
And that made a mess of everything so i had to delete the layer and start
over. So i wonder: maybe QGIS doesn't allow any other app to edit data in
its .gpkg files?

Reading deeper into tutorial [1], it seems that DB Browser needs a
spatialite extension (mod_spatialite.dylib for Mac 64), which good folks at
Fulcrum have kindly provided via their Github repo [2]... But following
dead-simple instructions given in tutorial [1], my installation fails with
the error msg:

> Error loading extension:
> dlopen(/Users/walterludwick/Desktop/mod_spatialite.dylib.dyylib, 10): image
> not found

(Strange: that redundant .dylib extension is not in the filepath i chose,
but... So it goes)

Anyway: i know this isn't the forum for DB Browser support, but because it
is so widely adopted in QGIS (and FOSS more generally) world, i just wonder
if anyone here is using it, and if so might be able to shed any light on
this problem.  ?

NOTES:
[1] Tutorial:  https://www.fulcrumapp.com/blog/working-with-geodata/
[2] Spatialite for DB Browser:  https://github.com/fulcrumapp/spatialite-bin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200813/508abd52/attachment.html>