[R-SIG-Mac] Update underlying SQLite for RSQLite

[Dan Tenenbaum]

----- Original Message -----
> From: "Merton Lister" <mrtnlstr at gmail.com>
> To: "Prof Brian Ripley" <ripley at stats.ox.ac.uk>
> Cc: r-sig-mac at r-project.org
> 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
> <ripley at stats.ox.ac.uk>
> 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
> >>> R-SIG-Mac at r-project.org
> >>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
> >>>
> >>
> >> David Winsemius
> >> Alameda, CA, USA
> >>
> >> _______________________________________________
> >> R-SIG-Mac mailing list
> >> R-SIG-Mac at r-project.org
> >> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
> >>
> >>
> >
> > --
> > Brian D. Ripley,                  ripley at stats.ox.ac.uk
> > 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
> R-SIG-Mac at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>