dbDriver-methods {RSQLite} | R Documentation |
SQLite driver initialization and closing
SQLiteDriver
as created by
dbDriver
.
drvName
.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or
http://stat.bell-labs.com/RS-DBI.
SQLite
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbListTables
,
dbReadTable
.
## Not run: # create an SQLite instance for capacity of up to 25 simultaneous # connections. m <- dbDriver("SQLite", max.con = 25) con <- dbConnect(m, dbname="sqlite.db") rs <- dbSubmitQuery(con, "select * from HTTP_ACCESS where IP_ADDRESS = '127.0.0.1'") df <- fetch(rs, n = 50) df2 <- fetch(rs, n = -1) dbClearResult(rs) pcon <- dbConnect(p, "user", "password", "dbname") dbListTables(pcon) ## End(Not run)