Rechercher une page de manuel
grass-sqlite
Langue: en
Version: 150368 (fedora - 04/07/09)
Section: 1 (Commandes utilisateur)
Sommaire
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing. 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:# 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).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
SQLite web site, SQLite manual, db.connect, db.execute, SQL support in GRASS GIS, sqlite - Management ToolsLast changed: $Date: 2007-07-18 16:10:27 +0200 (Wed, 18 Jul 2007) $
Help Index
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre