[GRASS-user] getting from DBF to SQLite

[Michael Barton]

As I've recently learned, portability across different platforms begins to be a real headache for files greater than 4 GB. All have drive formats and architecture that can support big files, but they are not common across platforms.


Michael
______________________________
C. Michael Barton
Director, Center for Social Dynamics & Complexity
Professor of Anthropology, School of Human Evolution & Social Change
Arizona State University
Tempe, AZ  85287-2402
USA

voice:  480-965-6262 (SHESC), 480-727-9746 (CSDC)
fax:          480-965-7671(SHESC), 480-727-0709 (CSDC)
www:  http://csdc.asu.edu, http://shesc.asu.edu
http://www.public.asu.edu/~cmbarton

On Feb 14, 2013, at 5:55 AM, grass-user-request at lists.osgeo.org<mailto:grass-user-request at lists.osgeo.org> wrote:

From: Markus Metz <markus.metz.giswork at gmail.com<mailto:markus.metz.giswork at gmail.com>>
Subject: Re: [GRASS-user] getting from DBF to SQLite
Date: February 14, 2013 1:38:57 AM MST
To: Hamish <hamish_b at yahoo.com<mailto:hamish_b at yahoo.com>>
Cc: GRASS user list <grass-user at lists.osgeo.org<mailto:grass-user at lists.osgeo.org>>


On Thu, Feb 14, 2013 at 12:50 AM, Hamish <hamish_b at yahoo.com<mailto: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<mailto: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/20130214/146f64b3/attachment-0001.html>