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

[Prof Brian Ripley]

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