[GRASS5] Re: question about sqlite

[Maciek Sieczka]

Daniel,

Thanks for your message. You have answered questions I have tried to ask
on the grasslist recently but didn't know how to, being a woose in DB stuff.

My 0,01 PLN: if sqlite improves the v.* and db.* modules speed, as weel
as provides functionality to drop/rename/change type of columns without
all the complexity of Postgresql I, a simple user, am all my hands and
legs for making it a default DB backend in Grass 6.1.

Thanks Radim for your effort on implementing sqlite in Grass, and BTW 
for all the recent wonders you have contributed to Qgis-Grass
interoperability.

Maciek


Daniel Calvelo Aros napisał(a):
> From: Radim Blazek <radim.blazek at gmail.com>
> Sent: Wed, 19 Oct 2005 10:22:09 +0200
> 
>>On 10/18/05, Michael Barton <michael.barton at asu.edu> wrote:
>>
>>>Radim,
>>>
>>>Could you give me a quick overview of what it means to compile GRASS with
>>>sqlite? Here are a couple questions I have.
>>>
>>>1) Is it simply a driver that lets GRASS recognize a database/table created
>>>by sqlite in an active sqlite session started in another process, like a
>>>Postgresql table in an active Postgresql session?
> 
> 
> Not quite. A SQLite "database" is a file, just like with DBF. There is no
> client-server infrastructure for SQLite. SQLite is transactional, so you can
> open the same file in two sessions, and there will be concurrent access,
> mostly problem-free.
> 
> 
>>>2) Does it/can it active an sqlite session from within GRASS?
> 
> 
> What it does is access the indicated sqlite file using the SQLite language and
> tranaction infrastructure, through the libsqlite library.
> 
> 
>>>3) Are there other features that I'm not asking about that I should know?
>>
>>The sqlite driver works like any other db driver (dbf, pg, mysql,
>> odbc). You can use an existing database or create a new one from GRASS.
>>Just set the driver and database file with db.connect and all new
>>attribute tables will be created in that database.
>>
>>Radim
> 
> 
> _______________________________________________
> grass5 mailing list
> grass5 at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5
> 
> 




--------------------
W polskim Internecie są setki milionów stron. My przekazujemy Tobie tylko najlepsze z nich!
http://katalog.epf.pl/