Martin wrote:
Probably we could move to SQLite in GRASS 6.5. Note there
are still remaining bugs,
would there be any backwards-compatibility issues?
we would first have to fix those bugs and get the optional per-map|mapset bits ready before doing the change.
> todo: for sqlite decide if we want per-map DB files
> like with DBF or single DB file per mapset.
...
I would vote for both approaches. User can decide what he
prefers via environmental variable, e.g. GRASS_SQLITE_PER_MAPSET.
I think it would have to be a g.gisenv variable, or perhaps stored in
the $MAPSET/VAR file.
which way would be the default?
Hamish
On 07/05/09 14:04, Hamish wrote:
todo: for sqlite decide if we want per-map DB files
like with DBF or single DB file per mapset.
...
I would vote for both approaches. User can decide what he
prefers via environmental variable, e.g. GRASS_SQLITE_PER_MAPSET.
I think it would have to be a g.gisenv variable, or perhaps stored in
the $MAPSET/VAR file.
which way would be the default?
I would plead for per mapset as this allows for more complete database approach (i.e. joins, views, etc).
Moritz
On Thursday 07 May 2009, Moritz Lennert wrote:
On 07/05/09 14:04, Hamish wrote:
>>> todo: for sqlite decide if we want per-map DB files
>>> like with DBF or single DB file per mapset.
>
> ...
>
>> I would vote for both approaches. User can decide what he
>> prefers via environmental variable, e.g. GRASS_SQLITE_PER_MAPSET.
>
> I think it would have to be a g.gisenv variable, or perhaps stored in
> the $MAPSET/VAR file.
>
> which way would be the default?
I would plead for per mapset as this allows for more complete database
approach (i.e. joins, views, etc).
Moritz
I also agree on this matter. I think that one thing that is making this
decision particularly difficult is that we are lacking a robust interchange
format for complex vector data. Dumping from GRASS vectors --> shapefiles -->
GRASS can sometimes lead to data loss. I wonder if further development of the
SQLite spatial datatypes would help address this problem.
Dylan
--
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341