[GRASS-user] GRASS 7 and SQLITE o POSTGRES

[Benjamin Ducke]

Hi Gabriele,

A spatial database extension allows you to store
geographic features as part of the database itself.
There are many advantages to this, especially if you
work with huge vector datasets.

SQLite has a spatial extension equivalent to PostGIS.
It is called SpatiaLite. It has the same functionality
as PostGIS. The latest version of OGR already has some
basic support for SQLite, so hopefully in the near future
all open source GIS will support SQLite/SpatiaLite as
a datasource.

However, if you are planning to to set up a spatial data
infrastructure for collaborative work, you should probably
choose PostgreSQL/PostGIS as your data backend, because
it supports user access control and is currently better
supported by open source GIS.

Ben

----- Original Message -----
From: "Gabriele N." <gis.gn at libero.it>
To: grass-user at lists.osgeo.org
Sent: Friday, February 20, 2009 5:38:48 PM GMT +00:00 GMT Britain, Ireland, Portugal
Subject: [GRASS-user] GRASS 7 and SQLITE o POSTGRES


Hello.
I work with colleagues sharing the files (shapes .. etc) that are on a NAS
server.
I use ubuntu 8.10 (with GRASS locally) and my colleagues use windows.

I would do this:
- A GIS with all these data 
- Building a database (sqlite or postgres/postgis/ on NAS)
- An excellent organization of the data
- To enable access to data with other software (such as QGIS and gvSIG)

GRASS 7 will default SQLite and therefore should be different to GRASS 6. In
the sense that now GRASS 6 connects to the DB (postgres and / or sqlite) but
works differently than the dbf ... or wrong?

SQLite does not have the spatial component as postgis with postgres? What
does this?

Can you tell me the steps to follow?
What do you recommend?

Thanks
Gabriele
-- 
View this message in context: http://n2.nabble.com/GRASS-7-and-SQLITE-o-POSTGRES-tp2360247p2360247.html
Sent from the Grass - Users mailing list archive at Nabble.com.

_______________________________________________
grass-user mailing list
grass-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user



------
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information.