dbxConnect function

Create a database connection

dbxConnect(
  url = NULL,
  adapter = NULL,
  storage_tz = NULL,
  variables = list(),
  ...
)

Arguments

• url: A database URL
• adapter: The database adapter to use
• storage_tz: The time zone timestamps are stored in
• variables: Session variables
• ...: Arguments to pass to dbConnect

Examples

# SQLite
db <- dbxConnect(adapter="sqlite", dbname=":memory:")

## Not run:

# Postgres
db <- dbxConnect(adapter="postgres", dbname="mydb")

# MySQL
db <- dbxConnect(adapter="mysql", dbname="mydb")

# Others
db <- dbxConnect(adapter=odbc(), database="mydb")
## End(Not run)