dplyr integration from MonetDB.R

Share:

Description

Use src_monetdb to connect to an existing MonetDB database, and tbl to connect to tables within that database. Please note that the ORDER BY, LIMIT and OFFSET keywords are not supported in the query when using tbl on a connection to a MonetDB database. If you are running a local database, you only need to define the name of the database you want to connect to.

Usage

1
2
3
4
5
src_monetdb(dbname, host = "localhost", port = 50000L, user = "monetdb",
  password = "monetdb", con=FALSE, ...)

## S3 method for class 'src_monetdb'
tbl(src, from, ...)

Arguments

dbname

Database name

host,port

Host name and port number of database (defaults to localhost:50000)

user,password

User name and password (if needed)

con

Existing DBI connection to MonetDB to be re-used

...

for the src, other arguments passed on to the underlying database connector, dbConnect.

src

a MonetDB src created with src_monetdb.

from

Either a string giving the name of table in database, or SQL described a derived table or compound join.

Examples

1
2
3
4
5
6
7
8
9
## Not run: 
library(dplyr)
# Connection basics ---------------------------------------------------------
# To connect to a database first create a src:
my_db <- MonetDB.R::src_monetdb(dbname="demo")
# Then reference a tbl within that src
my_tbl <- tbl(my_db, "my_table")

## End(Not run)