search

agstudy / rsqlserver

Sql Server driver database interface (DBI) driver for R. This is a DBI-compliant Sql Server driver based on the System.Data.SqlClient.
82 stars 30 forks source link

linux support question #9

Closed jangorecki closed 9 years ago

jangorecki commented 9 years ago

Any future plans to support linux?

If no, maybe some recommendation for high performance MSSQL connection from R on linux? doesn't have to be DBI compliant. Regards

steadyfish commented 9 years ago

I tried a few things for accessing MSSQL from linux; Finally ended up using ff suite of packages (ff,ffbase,ETLUtils,ffbase2) coupled with dplyr.

jangorecki commented 9 years ago

So you mean you resigned to use MSSQL at all? I didn't find mentioned tools to be related to sql server.

steadyfish commented 9 years ago

Essentially, Yes. For my purposes, I don't mind doing all the data processing etc, outside the db.

The ff suite of packages provide with functions to read from any db (e.g. read.jdbc.ffdf from ETLUtils) and still do out of memory processing (ffbase2 with dplyr) which works out fine for me.

jangorecki commented 9 years ago

Really interesting, it looks like my package dwtools is heavily related to that one. It looks promising to integrate with it. Thanks for the information!

jangorecki commented 9 years ago

reopening, would be nice to get an update from @agstudy

agstudy commented 9 years ago

Sorry to not answer before. For financial problems, I can't work on this package for the moment. Any help is welcome( coding this part or donation)

agstudy commented 9 years ago

Mono version is available now. It is under tests and 90 % percent of functionalities works fine.

jangorecki commented 9 years ago

Don't have sql server now to do my tests. Once I will have one I will try it. Would be much easier if sql server would be available for ubuntu :)

agstudy commented 9 years ago

:) Maybe you can try with Sybase ( I am not sure the they use the same mono interface for 2 data bases). That's said , I am using a virtual machine , install windows ans SQL server express edition.