I have a 11Gb size dataframe named
data which i somehow have loaded to Rstudio. Now I have converted that to Sql database by using following code but my question is how can I save the
sqlite database to load it later even if I close rstudio. I want to save it in some kind of output format like a Rds file.
library(RSQLite) library(DBI) library(dplyr) library(dbplyr) con <- dbConnect(RSQLite::SQLite(),dbame="ShearTest3.sqlite") # Writing the data frame to the database dbWriteTable(con, name = "sh3", value = data ,rownames=FALSE,overwrite=T) # this is just makes a connection to the database. my_db <- tbl(con, "sh3")