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

[Merton Lister]

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?

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]]