MonetDB.R (version 0.8.0)

MonetDB.R: DBI database connector and virtual data object for MonetDB

Description

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

Usage

MonetDB.R ()

Value

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

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. 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.

See Also

dbConnect for documentation how to invoke the driver monet.frame for a data.frame()-like interface to the DB monetdb.server.setup to set up and start a local MonetDB server from R

Examples

conn <- dbConnect(MonetDB.R(), "monetdb://localhost/demo")
dbListTables(conn)
data(iris)
dbWriteTable(conn, "iris", iris)
dbGetQuery(conn, "SELECT COUNT(*) FROM iris;")
d <- dbReadTable(conn, "iris")