The goal of dbProject is to manage dbData objects and database connections in the dbverse ecosystem.
You can install the development version of dbProject like so:
pak::pak("dbverse-org/dbproject-r")This is a basic example which shows you how to solve a common problem:
library(dbProject)
project_dir <- tempfile("dbproject_demo")
project <- dbProject$new(path = project_dir)
con <- project$get_conn()
DBI::dbWriteTable(con, "mtcars", mtcars)
DBI::dbReadTable(con, "mtcars")
project$disconnect()
unlink(project_dir, recursive = TRUE)