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 >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> > _______________________________________________ > 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 _______________________________________________ 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
