[GRASS-user] getting from DBF to SQLite

[Markus Metz]

On Thu, Feb 14, 2013 at 12:50 AM, Hamish <hamish_b at yahoo.com> wrote:
> Richard wrote:
>> 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?
>
> organize your system as you like, but be sure to ask yourself what
> happens to portability with 32bit machines and/or filesystems when the overall DB file gets to be larger than 2gb or 4gb in size.

The maximum file size of a SQLite db is 140 TB, independent of the
architecture, i.e. LFS is always there. Usually SQLite will hit the
maximum file size limit of the underlying filesystem or disk hardware
size limit long before it hits its own internal size limit [0].

Markus M

[0] http://www.sqlite.org/fileformat2.html


> Even per-mapset sqlite DBs worry me a bit for that, not to mention
> the damage-fallout from a bad HD sector or accidental `rm` and
> ease of moving stuff to another mapset/ system by hand.
>
>
> Hamish
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user