sqlite and grass65: was Re: [GRASS-dev] sqlite and grass64

Benjamin Ducke benjamin.ducke at oxfordarch.co.uk
Tue Mar 17 07:24:48 EDT 2009

Re. the missing functionality of DBF, would it be feasible
for v.db.join to import the DBF table to a temp SQLite file,
do the join and export it back to a DBF?
Would the same thing be possible for other SQL ops that DBF
does not support? For where=SQL module options?

It should be possible to ship SQLite with GRASS, shouldn't
it -- given it's highly portable and consumes < 250K? Plus
can be fully embedded w/o conflicting with system-wide

I suppose SpatiaLite would be an ideal exchange format
for vector maps.

Just some thoughts...



Moritz Lennert wrote:
> On 06/03/09 01:24, Moskovitz, Bob wrote:
>>>> Concerning the need to be able to easily backup/share, I 
>>> think we definitely
>>>> need some module which isolates and exports a series of 
>>> chosen maps in a new
>>>> temporary mapset with a local sqlite db file, copies the 
>>> chosen maps into
>>>> this temp mapset and then creates a tarball (or zip or 
>>> whatever) with the
>>>> basic LOCATION info (i.e. a PERMANENT mapset with PROJ and 
>>> WIND files) and
>>>> the temp mapset. Shouldn't be too hard to wip up, or ?
>>> Essentially a v.pack/v.unpack, right?
>>> Markus
>> What would be really neat is if there was a way to delete, as well as 
>> archive a location from the startup screen.
> That should actually be much easier. Deleting just implies removing the 
> directory from the file system, archiving just needs a call to create a 
> tar ball or equivalent. So, essentially a small GUI to call one single 
> command.
> v.pack/v.unpack would be different in that it should deal with 
> individual maps. even though I suggest to include the location info as 
> sort of meta-data, but also to give the possibility to v.unpack into a 
> new, stand-alone location. Don't know if the last is really necessary, 
> though. Just including necessary meta-data concerning the projection 
> system should be enough.
> Moritz
>> Bob
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev

Benjamin Ducke
Senior Applications Support and Development Officer

Oxford Archaeology
Janus House
Osney Mead
Oxford, U.K.

Tel.: ++44 (0)1865 263 800
benjamin.ducke at oxfordarch.co.uk

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.

More information about the grass-dev mailing list