dbDriver-methods

0th

Percentile

SQLite implementation of the Database Interface (DBI) classes and drivers

SQLite driver initialization and closing

Keywords
methods, interface, database
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, dbListTables, dbReadTable.

Aliases
  • dbDriver-methods
  • dbUnloadDriver-methods
  • dbDriver,character-method
  • dbUnloadDriver,SQLiteDriver-method
Examples
# 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)
Documentation reproduced from package RSQLite, version 0.8-2, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.