NAME¶
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
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 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.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 (corresponds to above
database connection):
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
SEE ALSO¶
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2012-09-07 10:20:29 +0200 (Fri, 07 Sep 2012) $
Main index - database index - full index