dbConnect-methods {RSQLite}R Documentation

Create a connection object to an SQLite DBMS

Description

These methods are straight-forward implementations of the corresponding generic functions.

Methods

drv
an object of class SQLiteDriver, or the character string "SQLite" or an SQLiteConnection.
conn
an SQLiteConnection object as produced by dbConnect.
...
As of RSQLite 0.4-1 you may specify values for the two PRAGMAs cache\_size and synchronous when initializing a new connection (this does not applies, obviously, to cloning an existing connection).

RSQLite defaults synchronous to 0 (or "OFF"), although SQLite's default as of 3.2.8 is 2 (FULL). Possible values for synchronous are 0, 1, or 2 or the corresponding strings "OFF", "NORMAL", or "FULL". Users have reported significant speed ups using sychronous=0, and the SQLite documentation itself implies considerable improved performance at the very modest risk of database corruption in the unlikely case of the operating system (not the R application) crashing. See the SQLite documentation for the full details of this PRAGMA.

cache\_size can be a positive integer to change the maximum number of disk pages that SQLite holds in memory (SQLite's default is 2000 pages).

Side Effects

A connection between R/S-Plus and the embeddable SQLite server is established. Note that since the SQLite is embedded in R/S-Plus, connections are not too resource hungry.

SQLite connections only require the file name where the SQLite database reside. For details see SQLite.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

SQLite, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.


[Package RSQLite version 0.6-9 Index]