grass-sqlite(1grass) GRASS GIS User's Manual grass-sqlite(1grass)
SQLite DATABASE DRIVER
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).
Connecting GRASS to SQLite
The database name ’sqlite.db’ is at user’s choice. Also the file stor-
age 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
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help
page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file
stored within the current mapset, the following way is suggested (cor-
responds 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
SEE ALSO
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Main index | Topics index | Keywords index | Graphical index | Full in-
dex
© 2003-2022 GRASS Development Team, GRASS GIS 7.8.7 Reference Manual
GRASS 7.8.7 grass-sqlite(1grass)
Generated by dwww version 1.14 on Sun Dec 29 18:28:02 CET 2024.