# 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)
Run the code above in your browser using DataLab