[Qgis-developer] A couple of ideas for QGIS

[roy roy]

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

-coordinate tranformation

-SQL VIEWS

-non spatial tables

-i mean is it a fully featured database
or does it uses another language ?

-High level difference beetween geopackage
and spatialite?

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 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.
>
> Bests
>
> Matthias
>
> 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,
>>
>> Roy.
>>
>>
>> _______________________________________________
>> 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