[GRASS-dev] sqlite and grass64

[William Kyngesburye]

On Jan 13, 2008, at 5:55 PM, Glynn Clements wrote:

>> AFAIU SQLite (by default) stores the DBs for all vector maps in a
>> single file per mapset. This makes it hard to share individual vector
>> maps and may have LFS issues when your data + mapset gets to be huge.
>> (??)
>
> It probably wouldn't be hard to modify the SQLite DBMI driver to allow
> one file per map (like for DBF), but then you lose the ability to
> perform joins (OTOH, if you're using DBF, you never had this ability
> in the first place).
>

I also like the idea of one db file per map.  But I didn't know about  
the join problem (I can see joins being useful).  Perhaps a db extract  
command can be added for when one wants to isolate a map's files?

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

"We are at war with them. Neither in hatred nor revenge and with no  
particular pleasure I shall kill every ___ I can until the war is  
over. That is my duty."

"Don't you even hate 'em?"

"What good would it do if I did? If all the many millions of people of  
the allied nations devoted an entire year exclusively to hating the  
____ it wouldn't kill one ___ nor shorten the war one day."

<Ha, ha> "And it might give 'em all stomach ulcers."

- Tarzan, on war