[Qgis-developer] Get rid of Shapefiles ! Go GeoJSON !

[Stefan Keller]

Hi Andreas

You are completely right if you are using the database as a
(centralized) data management store.
But to me, when one is speaking about a "desktop storage and exchange
format" it's an advantage when it's not so strict.
At least SQlite/Spatialite (compared to shp) is a single file and
offers attribute names which are self-explanatory (meaning longer than
8 chars).

Stefan


2012/11/27 Andreas Neumann <a.neumann at carto.net>:
> hm - I am not sure if loose data types are really an advantage. I like the
> more stricter handling of PostgreSQL better where you can constraint the
> data the user enters by stricter data types. In SQLite you can store all
> sort of unexpected crap into the fields. I know, you could do check
> constraints in SQLite, but it requires more work.
>
> So to me personally, looser data types are a disadvantage. There is a reason
> why 90% of all databases have stricter data types.
>
> Andreas
>
>
> On Tue, 27 Nov 2012 00:34:32 -0800 (PST), haubourg wrote:
>>
>> Stefan Keller wrote
>>>
>>> SQlite (Spatialite) is a database with data types which are as loose
>>> as they can get!
>>> What do you mean by saying Spatialite is more restrictive (than
>>> shp/dbase data types)?
>>>
>>> Stefan
>>> _______________________________________________
>>> Qgis-developer mailing list
>>
>>
>>> Qgis-developer at .osgeo
>>
>>
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>>
>> You are right, I didn't check well enough. Data types are loose. One more
>> reason to go to spatialite.
>> Thanks for correcting me.
>> http://www.sqlite.org/datatype3.html
>>
>>
>>
>>
>> --
>> View this message in context:
>>
>>
>> http://osgeo-org.1560.n6.nabble.com/Get-rid-of-Shapefiles-Go-GeoJSON-tp5018803p5018967.html
>> Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> --
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Switzerland
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer