dbDriver-methods {RSQLite} | R Documentation

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

### Description

SQLite driver initialization and closing

### Methods

drvName
  character name of the driver to instantiate.
drv
  an object that inherits from `SQLiteDriver` as created by `dbDriver`.
...
  any other arguments are passed to the driver `drvName`.

### References

See the Database Interface definition document `DBI.pdf` in the base directory of this package or http://developer.r-project.org/db.

### See Also

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

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

[Package Contents]