[GRASS-dev] tgis.db

[Markus Metz]

On Sat, Dec 8, 2012 at 1:25 PM, Sören Gebbert
<soerengebbert at googlemail.com> wrote:
> 2012/12/8 Martin Landa <landa.martin at gmail.com>:
>> 2012/12/8 Martin Landa <landa.martin at gmail.com>:
>>> default database [1]. Default DB for SQLite driver has been changed in
>>> r52829 [2].
>>
>> looking at the comment (see the [2]), I am not sure if it's a good
>> idea to have more SQLite DBs in one directory. Probably MarkusM could
>> elaborate on that...
>
> I see, sqlite is fsyncing its directory. So it may not be a good idea
> to have two sqlite databases in the same directory
> or in nested sub-directories.

I have not tested this case, maybe it works. What does not work is if
an application is opening a file and another application is opening a
sqlite db in the same folder. The GRASS sqlite driver should print
reasonable error messages, so it should be easy to test
>
> Maybe its a better idea to use a separate directory like tgis or temporal?

According to the sqlite documentation, that should be fail-safe.

Markus M