[R-SIG-Mac] Update underlying SQLite for RSQLite
Prof Brian Ripley
ripley at stats.ox.ac.uk
Sun Sep 27 11:26:27 CEST 2015
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
The current sources are
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
unzip -j ../../../sqlite-amalgamation-3081101.zip
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:
>> 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:
>> 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: 220.127.116.11.
> 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:
>> [[alternative HTML version deleted]]
>> R-SIG-Mac mailing list
>> R-SIG-Mac at r-project.org
> David Winsemius
> Alameda, CA, USA
> R-SIG-Mac mailing list
> R-SIG-Mac at r-project.org
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
More information about the R-SIG-Mac