Create sqlite from R dataframes

df_to_sqlite.R

library(DBI)
library(tidyverse)


# Import SPSS -------------------------------------------------------------

cleaned_dataframe_with_spss_data <- ....


# Write to DB -------------------------------------------------------------

import <- cleaned_dataframe_with_spss_data

# creates db.sqlite file if it doesn't exist
con <- dbConnect(RSQLite::SQLite(), "db.sqlite")
dbWriteTable(con, "tbl_name",  import)
dbDisconnect(con)


# Query data --------------------------------------------------------------

con <- dbConnect(RSQLite::SQLite(), "db.sqlite")
local_df <- tb(con, "tbl_name") %>% 
  filter(...) %>% 
  collect()
dbDisconnect(con)