Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.
SQLite DATABASE DRIVER
The SQLite driver is the default DBMI backend.
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
All SQL commands supported by SQLite (for limitations, see
SQLite help page:
SQL As Understood By SQLite and
Unsupported SQL).
All SQL operators supported by SQLite.
A convenient SQLite front-end is
sqlitebrowser.
To open a DB file stored within the current mapset,
the following way is suggested (corresponds to above database connection):
# fetch GRASS variables as shell environment variables:
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite/sqlite.db
db.connect,
db.execute,
db.select
SQL support in GRASS GIS
SQLite web site,
SQLite manual,
sqlite - Management Tools
Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.
Main index |
Topics index |
Keywords index |
Graphical index |
Full index
© 2003-2023
GRASS Development Team,
GRASS GIS 7.8.8dev Reference Manual