GRASS GIS Manual: SQLite DATABASE DRIVER

Note: A new GRASS GIS stable version has been released: GRASS GIS 7.4, available here.
Updated manual page: here

SQLite DATABASE DRIVER

Creating a SQLite database
Connecting GRASS to SQLite
Supported SQL commands
Operators available in conditions
Browsing table data in DB
SEE ALSO

The SQLite driver is the default DBMI backend.

Creating a SQLite database

GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is sufficient to define the connection (see next step).

The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it will be automatically created when database content is created:

# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'
db.connect -p

# fetch GRASS variables as shell environment variables:
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite/sqlite.db

SQLite DATABASE DRIVER

Table of contents

Creating a SQLite database

Connecting GRASS to SQLite

Supported SQL commands

Operators available in conditions

Browsing table data in DB

SEE ALSO