src_monetdb: dplyr integration from MonetDB.R

Description Usage Arguments Examples

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)


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

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.