[Qgis-user] columns in spatialite

[Paulo van Breugel]

On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas <a.neumann at carto.net>
wrote:

> 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
>
That would be a very big list of CRS, or does the query functionality take
that much space? I often used spatialite, but given that I normally use it
to store many layers, I had actually never noticed the large initial size.
This is imho indeed a clear disadvantage when used for data sharing.

> 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.
>

All files, not only the *.shp file. I just created a simple vector layer in
QGIS and saved it as shapefile, geopackage and spatialite file.

> Andreas
>
> On 2015-11-12 15:36, Paulo van Breugel wrote:
>
>
>
> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <matthias at 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 at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/ed072e8d/attachment.html>