Store a data frame in the MORIE cache — morie_cache_store • rmorie

Writes (or replaces) a table in the shared SQLite cache.

Usage

morie_cache_store(data, table_name, db_path = NULL, con = NULL)

Arguments

data: A data.frame to cache.
table_name: Name of the destination table.
db_path: Optional path to a SQLite file (default backend).
con: Optional pre-opened DBI connection. When supplied, the table is written through con and db_path is ignored. Use this for non-SQLite backends (PostgreSQL, DuckDB, MariaDB).

Value

Number of rows written (invisible).

Examples

# \donttest{
db <- tempfile(fileext = ".db")
morie_cache_store(
  data = data.frame(x = rnorm(50), y = rnorm(50)),
  table_name = "demo",
  db_path = db
)
file.remove(db)
#> [1] TRUE
# }