MonetDBLite (version 0.6.0)

MonetDB.R: DBI database connector for external MonetDB database

Description

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

Usage

MonetDB.R()

Value

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

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.

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

Run the code above in your browser using DataCamp Workspace