[Qgis-developer] A couple of ideas for QGIS
royroge at outlook.com
Tue Apr 4 02:27:21 PDT 2017
Thanks Mattias for the info,
I do not have a predetermined preference
between geopackage and spatialite
if you don't mind,
i do not know very well the gpkg format but
I understand that it's not spatialite.
I'd like to understand the pros or cons
between the two formats
does geopackage support:
-SQLite SQL language with triggers
joins aggregate etc..
-SQL spatial query
-non spatial tables
-i mean is it a fully featured database
or does it uses another language ?
-High level difference beetween geopackage
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
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 Roy,
> These are both addressed for geopackage already.
> Number one is a core feature (thanks to Even Rouault), number two is a
> plugin called "qgpkg" (thanks to Sourcepole) and would IMO really be a
> good candidate for core functionality.
> On 4/3/17 9:37 AM, roy roy wrote:
>> Dear QGIS Developers,
>> I think QGIS would benefit adding the following features;
>> if you find them interesting they may be added to QGIS 3.0:
>> 1 - Better support for Spatialite tables:
>> it is now impossible to remove columns from a spatialite
>> table, i know it's not supported by SQLite but there is a
>> simple work around that consists in creating a new table
>> without the removed column/s
>> 2 - Save project data into SQLite/Spatialite db:
>> this would grant users the choice to save all the work
>> in one unique file ( data, layer style ), very handy for
>> backups and sharing/shipping
>> i'm not a c++ developer but i can help with docs
>> and testing.
>> best regards,
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
More information about the Qgis-developer