dbxConnect {dbx}R Documentation

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

## 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)

[Package dbx version 0.3.1 Index]