RSQLite and reading data into memory

Question

It is possible that I missed something, but when using the RSQLite package, you can still use the special line ": memory:" in the R script in order to speed up data retrieval?

Answer 1

Yes, you can still use a special line :memory: ?RSQLite:::dbGetInfo look at the help file in ?RSQLite:::dbGetInfo , it has a good example:

 library(RSQLite) data(USArrests) drv <- dbDriver("SQLite") con <- dbConnect(drv, dbname=":memory:")