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
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user