src_monetdb: dplyr integration from MonetDB.R

Description Usage Arguments Examples

View source: R/dplyr.R

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)

MonetDB.R documentation built on May 29, 2017, 5:43 p.m.

Search within the MonetDB.R package
Search all R packages, documentation and source code