[Qgis-developer] A couple of ideas for QGIS

[Richard Duivenvoorde]

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/