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