RSQLite and read data into memory

September 22, 2021By Simo Sqlite

I may have overlooked something, but when using the RSQLite package, can I still use the special string “:memory:” in the R script to speed up data retrieval?

Yes, it can still use the special string: memory:. Take a look? RSQLite ::: dbGetInfo help file, it has a good example:

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

I may have overlooked some Something, but when using the RSQLite package, is it still possible to use the special string ":memory:" in the R script to speed up data retrieval?

Yes, it can still use special strings: memory:. Take a look? RSQLite ::: dbGetInfo help file, it has a good example:

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

data, memory, read, RSQLite, will

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 870 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment Cancel reply