search

archeos / ArcheOS

The main repository
34 stars 8 forks source link

Include R packages to connect sqlite #10

Closed lucaarcteam closed 12 years ago

lucaarcteam commented 12 years ago

The following packages should be installed: * r-cran-dbi * r-cran-sqlite To connect R and sqlite DB.

(thanks to Denis for suggestion)

lucaarcteam commented 12 years ago

For r-cran-dbi: http://packages.debian.org/squeeze/r-cran-dbi r-cran-sqlite is missing. we have to build and test a specific apckage for ArcheOS.

fabfurnari commented 12 years ago

r-cran-dbi is already intalled into ArcheOS Caesar I cannot find r-cran-sqlite as debian package, so I think the best option is to use the CRAN frontend to install it resolving all the dependencies, but this cannot be done in a clean automated way: the user himself must install it on ArcheOS...

fabfurnari commented 12 years ago

Uploaded r-cran-rsqlite into ArcheOS APT repositories from http://ftp.debian.org/debian/pool/main/r/r-cran-rsqlite/

fabfurnari commented 12 years ago

r-base-core must be to version 2.14 to satisfy r-cran-rsqlite depency. Update it

lucaarcteam commented 12 years ago

I tired to rebuild the original wheezy r-cran-rsqlite package, but it needs to be tested: http://dl.dropbox.com/u/63756486/ArcheOS/packages/r-cran-rsqlite_0.11.1-1_i386.deb

df79 commented 12 years ago

I tested Luca's package and it seems run, but with this warning: "In sqliteInitDriver(max.con, fetch.default.rec, force.reload, shared.cache) : RS-DBI driver warning: (SQLite mismatch between compiled version 3.7.9 and runtime version 3.7.10)" Maybe the wheezy package required a newer version of sqlite. This is just a warning, because the other functions run. I must confess that my test is limited because I've already installed R 2.15 and the problem was with R <2.14 (if I understood). I updated R with this debian backports: deb http://cran.ma.imperial.ac.uk/bin/linux/debian squeeze-cran/ deb-src http://cran.ma.imperial.ac.uk/bin/linux/debian squeeze-cran/