Establish a connection to the database using settings from .env file. This function creates a connection pool for efficient database access and provides options for local data storage when needed.
Value
A list containing the database connection pool (db
) and table name (table
),
or NULL
if ignore is TRUE
or if connection fails
Examples
if (interactive()) {
# Connect using settings from .env
db <- sd_db_connect()
# Use local storage instead of database
db <- sd_db_connect(ignore = TRUE)
# Close connection when done
if (!is.null(db)) {
pool::poolClose(db$db)
}
}