RMonet-package: MonetDB SQL Interface

In piersharding/RMonet: MonetDB SQL client interface for R

Description

Package RMonet MonetDB SQL Interface implemented using the MAPI client library.

See the package manual for details of installation and use. (This will show up as a vignette, and can be accessed via RShowDoc("RMonet", package="RMonet").)

Details

Read and write to tables in the MonetDB in-memory column store DB, using SQL over the MonetDB MAPI client library

con <- RMonetConnect("db.yml")

or

con <- RMonetConnect(dbhost="localhost", dbuser="voc", dbpass="voc", dbname="voc")

info = RMonetGetInfo(con) print(info)

parms <- list(3, 50) qry <- "SELECT * FROM voc.craftsmen WHERE trip > ? LIMIT ?"

res <- RMonetQuery(con, qry, parms) print(res) # alternative shorthand res <- dbquery(con, qry, parms) print(res) RMonetClose(con)

All Query results are returned as data.frame.

Note

Please see the README and INSTALL file that come with RMonet - these will give the latest info on how to install and test the package, inparticular details are given on how to setup the test database and run the test suite.

Author(s)

Piers Harding

See Also

RMonet, RMonetConnect, RMonetGetInfo, RMonetQuery, RMonetLoadDataFrame, RMonetExecute, RMonetClose, RMonetStartTransaction, RMonetCommit, RMonetRollback, RMonetIsConnected, RMonetQuote, RMonetUnQuote, RMonetExists, RMonetListTables, RMonetListFields

piersharding/RMonet documentation built on May 25, 2019, 6:09 a.m.