Perfect. Thanks! On Sun, Sep 27, 2015 at 6:19 PM, Dan Tenenbaum <[email protected]> wrote:
> > > ----- Original Message ----- > > From: "Merton Lister" <[email protected]> > > To: "Prof Brian Ripley" <[email protected]> > > Cc: [email protected] > > Sent: Sunday, September 27, 2015 5:20:14 PM > > Subject: Re: [R-SIG-Mac] Update underlying SQLite for RSQLite > > > > Thank you for pointing out the error in the doc, Prof. Ripley. > > > > I have built and installed RSQLite as per your instructions. Any way > > to > > double-check the version of SQLite engine actually used by RSQLite? > > Perhaps > > some attribute we can print out in the console? > > > library(RSQLite) > > db = dbConnect(SQLite(), dbname="") > > dbGetQuery(conn=db, "SELECT sqlite_version() AS 'SQLite Version'") > SQLite Version > 1 3.8.6 > > Dan > > > > > > > Best, > > Merton > > > > > > On Sun, Sep 27, 2015 at 2:26 AM, Prof Brian Ripley > > <[email protected]> > > wrote: > > > > > Those instructions are for updating the source package. As RSQLite > > > always > > > uses the version of SQLite included in its sources, installing > > > another > > > version will not help! You need to update the source package and > > > then > > > install it (which inter alia involves compiling the SQLite it > > > contains). > > > > > > The current sources are > > > > > > http://www.sqlite.org/2015/sqlite-amalgamation-3081101.zip > > > > > > and those instructions are not right, as that needs to be extracted > > > to > > > RSQLite/src/sqlite, not RSQLite/src . > > > > > > You can use something like > > > > > > curl -O http://www.sqlite.org/2015/sqlite-amalgamation-3081101.zip > > > tar xvf .../RSQLite_1.0.0.tar.gz > > > pushd RSQLite/src/sqlite > > > unzip -j ../../../sqlite-amalgamation-3081101.zip > > > rm shell.c > > > popd > > > R CMD INSTALL RSQLite > > > > > > Works for me .... > > > > > > > > > > > > > > > On 27/09/2015 08:00, David Winsemius wrote: > > > > > >> > > >> On Sep 26, 2015, at 5:02 PM, Merton Lister wrote: > > >> > > >> Hello, > > >>> > > >>> I've just installed R on my mac and installed some packages, but > > >>> I have a > > >>> couple of questions regarding updating a package. > > >>> > > >>> I've found some instructions on how to update version of SQLite > > >>> here: > > >>> https://github.com/rstats-db/RSQLite#update-version-of-sqlite. > > >>> > > >>> However, it is unclear to me how this will actually update the > > >>> underlying > > >>> SQLite engine used by RSQLite. If I execute the listed commands > > >>> in R > > >>> console, it seems that all they do is to download the a version > > >>> of SQLite > > >>> source code, and extract the files into 'src/' minus the > > >>> 'shell.c' file. > > >>> > > >>> I have two questions: 1. where exactly is this 'src/' directory? > > >>> > > >> > > >> I have no idea. These directions may be Linux specific. > > >> > > >> > > >> (is it > > >>> specifically for RSQLite only?) 2. After extracting the source > > >>> files, > > >>> don't > > >>> we need to compile them into RSQLite? > > >>> > > >> > > >> I would have thought so, too. This is the top of the description > > >> file for > > >> RSQLite > > >> ------------------ > > >> Version 1.0.0 > > >> > > >> Title SQLite Interface for R > > >> > > >> Package ‘RSQLite’ > > >> > > >> February 19, 2015 > > >> > > >> Description This package embeds the SQLite database engine in R > > >> and > > >> provides an interface compliant with the DBI package. > > >> The source for the SQLite engine (version 3.8.6) is included. > > >> ----------------- > > >> > > >> So that is (only?) 5 minor versions behind the current one: > > >> 3.8.11.1. > > >> > > >> There are precompiled versions for each of the three "standard" > > >> platforms at the SQLite website. I agree that unzipping a source > > >> version > > >> seems unlikely to change the compiled engine. If I were trying to > > >> be > > >> bleeding edgy, which I generally try to avoid, I would have > > >> installed the > > >> appropriate binary: > > >> > > >> http://www.sqlite.org/2015/sqlite-shell-osx-x86-3081101.zip > > >> > > >> > > >> Best, > > >>> Merton > > >>> > > >>> [[alternative HTML version deleted]] > > >>> > > >>> _______________________________________________ > > >>> R-SIG-Mac mailing list > > >>> [email protected] > > >>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac > > >>> > > >> > > >> David Winsemius > > >> Alameda, CA, USA > > >> > > >> _______________________________________________ > > >> R-SIG-Mac mailing list > > >> [email protected] > > >> https://stat.ethz.ch/mailman/listinfo/r-sig-mac > > >> > > >> > > > > > > -- > > > Brian D. Ripley, [email protected] > > > Emeritus Professor of Applied Statistics, University of Oxford > > > 1 South Parks Road, Oxford OX1 3TG, UK > > > > > > > [[alternative HTML version deleted]] > > > > _______________________________________________ > > R-SIG-Mac mailing list > > [email protected] > > https://stat.ethz.ch/mailman/listinfo/r-sig-mac > > > [[alternative HTML version deleted]] _______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
