[Qgis-user] columns in spatialite

[Alex M]

You are correct. In my mind the workflow is get GeoPackage -> up convert
to Spatialite -> do work -> Convert to GeoPackage to give to other people.

This is actually the same workflow that's been pushed in other software
too. Get exchange format, import to internal best database format, do
work, export to exchange format.

The export to exchange of whole projects/databases needs to be made
super simple (1-2 clicks) for it to become common.

-Alex

On 11/12/2015 06:48 AM, Neumann, Andreas 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 
> 
> 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 <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
> 
>   
> 
> 
> 
> _______________________________________________
> 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
>