MonetDB.R: DBI database connector for MonetDB

In MonetDB/monetdb-r: R DBI interface to MonetDB

Description

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

Usage

  MonetDB.R ()

Details

The MonetDB.R function creates an 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.

This package aims to provide a reasonably complete implementation of the DBI. A number of additional methods are provided: dbSendUpdate for database-altering statements, dbSendUpdateAsync for cleanup operations and monetdb.read.csv for database CSV import.

Value

Returns a driver object that can be used in calls to dbConnect.

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)
conn <- dbConnect(MonetDB.R::MonetDB(), dbname = "demo")
dbWriteTable(conn, "iris", iris)
dbListTables(conn)
dbGetQuery(conn, "SELECT COUNT(*) FROM iris")
d <- dbReadTable(conn, "iris")

## End(Not run)

MonetDB/monetdb-r documentation built on Sept. 22, 2020, 11:49 p.m.