Description Usage Details Value See Also Examples
MonetDB.R
creates a new DBI driver that can be used to connect and interact with external MonetDB database.
1 |
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.
Returns a driver object that can be used in calls to
dbConnect
with an external MonetDB database.
dbConnect
for documentation how to invoke the driver
monetdb.server.setup
to set up and start a local MonetDB server from R
1 2 3 4 5 6 7 8 9 | ## 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")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.