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

[Andreas Neumann]

 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