On 04-04-17 11:27, roy roy wrote: > I can grasp spatialite in 5 min knowing > that i'ts a fully featured SQL relational database > but cannot wrap my head around geopackage: > > "GeoPackage Encoding Standard governs the rules and requirements of content > stored in a GeoPackage container" ...so is geopackage a set of rules on > how data > should be store into an SQLite database? > > in the end (for now) i find spatialite much more > intuitive and i think QGIS would benefit > supporting at least point 1 (drop column from spatialite) > > thanks for any insight, Roy.
Hi, though not fully into the technical details, I know that gpkg is a sqlite db too; see [0] and [1], AND it is an open standard. Here: [2] you can read about descisions made why a new standard format is created and not took the already excisting spatialite. Using the 'spatialite_gui' I can open a gpkg package too. Using sqlitebrowser [3] also... I think it is good if as GIS / FOSS community we focus on one good standard package, so please give it a try :-) And please let us/me know what you miss (well one thing I would have to had in the standard is a standardized way of setting layer order and styling, independent on styling language or GIS used... :-) )... Regards, Richard Duivenvoorde [0] https://en.wikipedia.org/wiki/GeoPackage [1] http://www.geopackage.org/ [2] https://cholmes.wordpress.com/2013/08/20/spatialite-and-geopackage/ [3] http://sqlitebrowser.org/ _______________________________________________ Qgis-developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
