The SQLite driver is the default DBMI backend.

       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

       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

       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).

       All SQL operators supported by SQLite.

db.connect,db.execute,db.selectSQLsupportinGRASSGISSQLitewebsite,SQLitemanual,sqlite-ManagementTools

       Available at: SQLite DATABASE DRIVER source code (history)

       Accessed: Friday Apr 04 01:18:41 2025

       Main index | Topics index | Keywords index | Graphical index | Full index

       © 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual

GRASS 8.4.1                                                                                 grass-sqlite(1grass)

       The SQLite driver is the default DBMI backend.

       All  SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite
       and Unsupported SQL).