« DeployR 7.4.1 released | Main | Good advice for security with R »

August 18, 2015


Feed You can follow this conversation by subscribing to the comment feed for this post.

any info o rsqlserver package which uses kind of more native drivers? https://github.com/agstudy/rsqlserver

@jangorecki: rsqlserver depends on rClr which in turn depends on the .Net framework. Therefore it may have performance issues similar to RJDBC/RSQLServer due to the marshalling of objects from native to managed.

Can't tell for sure since on my test machine rClr failed to install due to a failure to download NuGet package http://www.nuget.org/packages/DynamicInterop

It's unclear what the root cause is. Here's what I tried in case that helps:
- bash
sudo apt-get install libssl-dev libcurl4-openssl-dev libxml2-dev mono-complete libglib2.0-dev libmonosgen-2.0-dev
- R
install_github("jmp75/rClr") # fails

the author of rsqlserver made some benchmarks on that, and recently it also supports linux. The benchmarks are really nice and I believe can be a best tool for connecting to sql server from R. At least as long as MS will not release native drivers like Oracle, MySQL or postgres

The comments to this entry are closed.

Search Revolutions Blog

Got comments or suggestions for the blog editor?
Email David Smith.
Follow revodavid on Twitter Follow David on Twitter: @revodavid
Get this blog via email with Blogtrottr