1grass-sqlite(1)               Grass User's Manual              grass-sqlite(1)
2
3
4
5SQLite driver in GRASS
6

Creating a SQLite database

8       GRASS  is  automatically  creating the SQLite database if it is not yet
9       existing. It is sufficient to define the connection (see next step).
10

Connecting GRASS to SQLite

12       The database name 'sqlite.db' is at user's choice.  Also the file stor‐
13       age  location  can be freely chosen. If the database does not exist, it
14       will be automatically created:
15       # example for storing DB in mapset directory (keep single quotes):
16       db.connect           driver=sqlite           database='$GISDBASE/$LOCA‐
17       TION_NAME/$MAPSET/sqlite.db'
18       db.connect -p
19
20

Supported SQL commands

22       All  SQL commands supported by SQLite (for limitations, see SQLite help
23       page: SQL As Understood By SQLite).
24

Operators available in conditions

26       All SQL operators supported by SQLite.
27

Browsing table data in DB

29       A convenient SQLite front-end is sqlitebrowser.   To  open  a  DB  file
30       stored  within the current mapset, the following way is suggested (cor‐
31       responds to above database connection):
32       eval `g.gisenv`
33       # use double quotes:
34       sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
35
36

SEE ALSO

38       SQLite web site, SQLite manual, db.connect, db.execute, SQL support  in
39       GRASS GIS, sqlite - Management Tools
40
41       Last changed: $Date: 2007-07-18 16:10:27 +0200 (Wed, 18 Jul 2007) $
42       Help Index
43
44
45
46GRASS 6.3.0                                                    grass-sqlite(1)