pdo_sqlite-dsn(3) [php man page]

PDO_SQLITE-DSN(3)							 1							 PDO_SQLITE-DSN(3)

PDO_SQLITE DSN - Connecting to SQLite databases

	The PDO_SQLITE Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix (SQLite 3)
		- The DSN prefix is sqlite:.

		     o To access a database on disk, append the absolute path to the DSN prefix.

		     o To create a database in memory, append
		       :memory: to the DSN prefix.

	      o DSN prefix (SQLite 2)
		-  The SQLite extension in PHP 5.1 provides a PDO driver that supports accessing and creating SQLite 2 databases. This enables you
		to access databases you may have created with the SQLite extension in previous versions of PHP.

	      Note

		      The sqlite2 driver is only available in PHP 5.1.x if you have enabled both PDO and ext/sqlite. It is not currently available
		     via PECL.

	       The DSN prefix for connecting to SQLite 2 databases is sqlite2:.

		     o To access a database on disk, append the absolute path to the DSN prefix.

		     o To create a database in memory, append
		       :memory: to the DSN prefix.

       Example #1

	      PDO_SQLITE DSN examples

	       The following examples show PDO_SQLITE DSN for connecting to SQLite databases:

	      sqlite:/opt/databases/mydb.sq3
	      sqlite::memory:
	      sqlite2:/opt/databases/mydb.sq2
	      sqlite2::memory:

PHP Documentation Group 													 PDO_SQLITE-DSN(3)

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)