| 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)