----- 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 > _______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
