dbxConnect: Create a database connection

In dbx: A Fast, Easy-to-Use Database Interface

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)

dbx documentation built on June 22, 2024, 9:11 a.m.