dbx (version 0.4.0)

dbxConnect: Create a database connection

Description

Create a database connection

Usage

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:")

if (FALSE) {

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

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

# Others
db <- dbxConnect(adapter=odbc(), database="mydb")
}