sqlitebrowser(1) [debian man page]

SQLITEBROWSER(1)					      General Commands Manual						  SQLITEBROWSER(1)

NAME

       sqlitebrowser - light GUI editor for SQLite databases

SYNOPSIS

       sqlitebrowser [file]

DESCRIPTION

       SQLite  Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for
       users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the  need	to
       learn complicated SQL commands.

SEE ALSO

       SQLitebrowser's home page: http://sqlitebrowser.sourceforge.net/.

AUTHOR

       sqlitebrowser  was  developed  originally  by Mauricio Piacentini from Tabuleiro Producoes. Icons were contributed by Raquel Ravanini, also
       from Tabuleiro. Jens Miltner contributed the code to support SQLite 3.x databases for the 1.2 release.
       In the spirit of the original SQLite source files, the authors disclaim copyright to this source code. It may be  used  as  the	basis  for
       other programs, public domain, open source or commercial. Do whatever you want with it.

       This manual page was written by Francois Fevotte <francois.fevotte@ensta.org>, for the Debian project (but may be used by others).
       Permission  is  granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any
       later version published by the Free Software Foundation.
       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

								  August  4, 2007						  SQLITEBROWSER(1)

grass-sqlite(1grass)						Grass User's Manual					      grass-sqlite(1grass)

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 (corre-
       sponds 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: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
       Help Index

GRASS 6.4.2														      grass-sqlite(1grass)