[Qgis-user] columns in spatialite

[Luigi Pirelli]

For different reasons I'm not fan or either geopackage and spatialite...
Btw, you can reduce the size of the spatialite if you create it only with
CR's of your data (and much Custer to create). A spatiallite with all CRS
is 4mb... With a single crs is some k but with all spatial operators
indside.


On Thursday, 12 November 2015, Paulo van Breugel <p.vanbreugel at gmail.com>
wrote:

>
>
> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <matthias at opengis.ch
> <javascript:_e(%7B%7D,'cvml','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
>>
>
>

-- 
Luigi Pirelli

**************************************************************************************************
* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS:
https://www.packtpub.com/application-development/mastering-qgis
**************************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151113/6caa1ddd/attachment.html>