Description Details Note Author(s) See Also
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")
.)
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.
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.
Piers Harding
RMonet
, RMonetConnect
, RMonetGetInfo
, RMonetQuery
, RMonetLoadDataFrame
, RMonetExecute
, RMonetClose
, RMonetStartTransaction
, RMonetCommit
, RMonetRollback
, RMonetIsConnected
, RMonetQuote
, RMonetUnQuote
, RMonetExists
, RMonetListTables
, RMonetListFields
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.