[Qgis-developer] Get rid of Shapefiles ! Go GeoJSON !
sfkeller at gmail.com
Tue Nov 27 00:49:48 PST 2012
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
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.
> 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)?
>>> Qgis-developer mailing list
>>> Qgis-developer at .osgeo
>> You are right, I didn't check well enough. Data types are loose. One more
>> reason to go to spatialite.
>> Thanks for correcting me.
>> View this message in context:
>> Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
More information about the Qgis-developer