search

datadotworld / data.world-r

R library for data.world
https://data.world/integrations/r
Apache License 2.0
59 stars 18 forks source link

Any chance of an R DBI implementation? #25

Open jameshowison opened 7 years ago

jameshowison commented 7 years ago

I'd love to use data.world as a backend for SQL but have it work in R Notebooks via the knitr {sql} engine. That enables students to simply write SQL and not have to worry about the R code around it.

Two ways forward I think:

  1. A datadotworld knitr engine (replacing the sql engine). I tried that but run into some trouble because R Notebooks via RStudio worked differently than straight Knitr. I posted about that on a comment at: http://rmarkdown.rstudio.com/authoring_knitr_engines.html (might still be in moderation?)

  2. Implement a (limited) DBI backend for the data.world API. That would be broadly useful but in this specific case it would make the knitr sql engine "just work". The basics of constructing a DBI compliant backend look like it might be possible? https://cran.r-project.org/web/packages/DBI/vignettes/backend.html

scottcame commented 5 years ago

In the past few months, an open source (CC0) DBI driver became available here: https://github.com/carljv/dwDBI