MonetDB backend about dplyr HOT 5 CLOSED

Basic R code:

library(MonetDB.R)
url <- paste0( "monetdb://localhost:50000/mydb")
db <- dbConnect(MonetDB.R(), url)

data(baseball, package = "plyr")
dbWriteTable(db, "baseball", baseball)

from dplyr.

How can I help?

from dplyr.

@hannesmuehleisen would you be interested in implementing the backend? It's not too much work and I can send you some instructions.

from dplyr.

@hadley Yes, I'll give it a shot. Instructions to [email protected] please!

from dplyr.

Hi @hannesmuehleisen , I tried out MonetDB today and the companion R package. From what I read in this link posted in your documentation: https://en.wikipedia.org/wiki/SQL, it looks like all MonetDB.R needs to support dbplyr are pointers to the appropriate MySQL translations. For example, simply adding a pointer to sql_translate_env() allowed tally() to work:

library(MonetDB.R)
library(DBI)
library(dplyr)
library(dbplyr)

con <- dbConnect(MonetDB.R(), host="localhost", dbname="demo", user="monetdb", password="monetdb")

sql_translate_env.MonetDBConnection <- dbplyr:::sql_translate_env.MySQLConnection

tbl(con, "mtcars") %>%
  tally()

tbl(con, "mtcars") %>%
  group_by(am) %>%
  tally()

From what I read in your documentation, I think you'll need to also point the SQL Transactions related functions

@hadley / @hannesmuehleisen - These updates could be done in either package, I'll be glad to sent over a PR if you guys think this should be done inside dbplyr

from dplyr.