src_scidb: src_scidb

In mdsr-book/mdsr: Complement to 'Modern Data Science with R'

src_scidb

Description

Connect to the scidb server on Amazon Web Services.

Usage

src_scidb(dbname, ...)

dbConnect_scidb(dbname, ...)

mysql_scidb(dbname, ...)

Arguments

dbname	the name of the database to which you want to connect
...	arguments passed to src_dbi or dbConnect

Details

This is a public, read-only account. Any abuse will be considered a hostile act.

Value

For src_scidb, a src_dbi object

For dbConnect_scidb, a MariaDBConnection-class object

For mysql_scidb, a character vector of length 1 to be used as an engine.ops argument, or on the command line.

See Also

src_dbi

MariaDBConnection-class

opts_chunk

Examples

## Not run: 
db_air <- src_scidb("airlines")
db_air

## End(Not run)
## Not run: 
db_air <- dbConnect_scidb("airlines")
db_air
if (require(DBI)) {
  dbListTables(db_air)
}

## End(Not run)

if (require(knitr)) {
  opts_chunk$set(engine.opts = mysql_scidb("airlines"))
}

mdsr-book/mdsr documentation built on Jan. 27, 2023, 1:57 p.m.