In mdlincoln/dbns: Load All Tables From A Database Into R Objects

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "README-"
)

dbns

dbns creates a DataBase NameSpace, adding all the tables available from a given database connection into a namespace as tbl objects ready to be manipulated by dplyr.

Example

library(dbns)
library(DBI)
db <- dbConnect(RSQLite::SQLite(), system.file("extdata/dbns.sqlite", package = "dbns"))

dbListTables(db)

attach_database(db, "dbns")

dbns_iris

dbns_mtcars

Detach a database namespace when you are done. Note that dbns does not disconnect the DBI connection.

detach_database("dbns")

dbDisconnect(db)

mdlincoln/dbns documentation built on May 20, 2019, 9:15 p.m.