[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

[Paulo van Breugel]

You can define the SQLite database yourself with db.connect. The 
database does only contain the attribute data, no geometric information, 
so you could define the same SQLite database for different mapsets and 
even locations. I tried this actually out some time ago, and it worked 
for me at the time. You can easily try out yourself, but see my next point.

Whether that is a smart thing to do is another point. Depending on how 
you set up your GRASS database, you might end up having layers with the 
same name in different mapsets or locations. In that case, you will run 
into trouble; you can't have more then one table with the same name in 
your SQLite database. I would therefore recommend having one SQLite 
database per mapset. There are also plans for a SQLite database per 
layer. I am not sure what would be the advantage of that though.

I am not sure about your second question, but GRASS 7 uses the SQLite 
database by default.

Paulo



On 04/09/2012 09:04 AM, Micha Silver wrote:
> On 09/04/2012 09:47, RichardC wrote:
>> Hi,
>>
>> I'm also planning to move from the DBF to SQLite database, and was wondering
>> if you might be able to help with the following.
>>
>> Is it is possible to set a single SQLite database for the entire GRASS GIS
>> database or each mapset requires its own sqlite db file?
>
> I'm pretty sure it's per mapset.
> Have a look at this nice summary blog post about db connections (from 
> 2009, but still accurate)
> http://casoilresource.lawr.ucdavis.edu/drupal/node/733
>> Currently, I'm using v6.4.2 which uses DBF by default. Is there a command
>> that can switch the installation to using SQLite as the default, so that
>> mapsets in subsequently created locations will use Sqlite? Or I need to
>> reconfigure the installation (i.e., the ./configure options prior to
>> make/make install)?
>>
>> Thanks,
>> Richard
>>
>> --
>> View this message in context:http://osgeo-org.1560.n6.nabble.com/getting-from-DBF-to-SQLite-tp4657601p4715248.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
>>
>> This mail was received via Mail-SeCure System.
>>
>>
>
>
>
> -- 
> Micha Silver
> 052-3665918
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20120409/497e3c59/attachment-0001.html