[GRASS-user] [GRASSLIST:1129] SQLite connection in GUI?

Is there any quick way to allow for sqlite to be a legit db driver in the
v.db commands (under the gui, I think it works fine via command line)? Why
was it removed (or was it never a selection option)? After 5 days of trying
to (unsuccessfully) get postgresql working under cygwin, sqlite took all of
2 seconds to download and install, so it's an attractive option for Windows
grass users...

--j

--

Jonathan A. Greenberg, PhD
NRC Research Associate
NASA Ames Research Center
MS 242-4
Moffett Field, CA 94035-1000
Phone: 415-794-5043
AIM: jgrn3007
MSN: jgrn3007@hotmail.com

Jonathan Greenberg wrote:

Is there any quick way to allow for sqlite to be a legit db driver in the
v.db commands (under the gui, I think it works fine via command line)? Why
was it removed (or was it never a selection option)? After 5 days of trying
to (unsuccessfully) get postgresql working under cygwin, sqlite took all of
2 seconds to download and install, so it's an attractive option for Windows
grass users...

does "db.drivers -p" list sqlite?

If not, GRASS wasn't configured and compiled with SQLite support.
IMO, all GRASS 6.1 binary packages should be including support for
SQLite.

If db.drives shows it, use db.connect to set it as the active db
connection. (see the db.connect help page)

db.connect -p
db.tables -p

Hamish