I believe the main difference between SpatiaLite and Geopackage is that a SpatiaLite database contains a lot of query functionality and additional data (e.g. a big list of CRS) - while Geopackage does not
When you checked filesizes for shp: did you only look at the shp, or also include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset with attributes and metadata against just geometry. Andreas On 2015-11-12 15:36, Paulo van Breugel wrote: > On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <matth...@opengis.ch> wrote: > >> The main issues with spatialite are IMO: It's based on sqlite so >> deleting columns and renaming columns is not supported by design. We >> could offer some hacks to bypass this (annoying restriction) from the UI >> - there is a risk of side effects though. Another property of it is, >> that it's already 4-5MB big, even when empty. I consider this a major >> limiting factor as well. Other issues which we were not yet able to >> solve are its management of the information scheme which keep duplicate >> entries of tables and columns which need to be properly updated which we >> apparently do not manage (yet). >> >> Geopackage is also based on sqlite, so the column delete/rename >> restrictions apply as well (with the same workaround possibilities). I >> haven't checked the file size, but if that's smaller, that would be >> quite nice (does somebody know?). > > Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage > file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then > the shapefile, but the increase is small compared to the spatialite file. I > am not familiar with the differences, but this makes the Geopackage a better > candidate imho. > >> All the best >> Matthias > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
