MonetDB.R: DBI database connector for external MonetDB database

In MonetDBLite: In-Process Version of 'MonetDB'

Description

MonetDB.R creates a new DBI driver that can be used to connect and interact with external MonetDB database.

Usage

  MonetDB.R()

Details

The MonetDB.R function creates the R object which can be used to a call dbConnect which actually creates the connection. Since it has no parameters, it is most commonly used inline with the dbConnect call.

All of the MonetDBLite::MonetDB.R() external server connection functions are discouraged in favor of embedded MonetDBLite::MonetDBLite() functions.

This package aims to provide a reasonably complete implementation of the DBI.

Value

Returns a driver object that can be used in calls to dbConnect with an external MonetDB database.

See Also

dbConnect for documentation how to invoke the driver monetdb.server.setup to set up and start a local MonetDB server from R

Examples

## Not run: 
library(DBI)
con <- dbConnect(MonetDBLite::MonetDB.R(), dbname = "demo")
dbWriteTable(con, "iris", iris)
dbListTables(con)
dbGetQuery(con, "SELECT COUNT(*) FROM iris")
d <- dbReadTable(con, "iris")

## End(Not run)

MonetDBLite documentation built on July 28, 2018, 1:02 a.m.