/usr/lib/R/site-library/RSQLite/INSTALL is in r-cran-rsqlite 0.11.2-1build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | RSQLite -- Embedding the SQLite engine in R
(The RSQLite package includes a recent copy of the SQLite
distribution from http://www.sqlite.org.)
Installation
------------
There are 3 alternatives for installation:
1. Simple installation:
R CMD INSTALL RSQLite-<version>.tar.gz
the installation automatically detects whether SQLite is
available in any of your system directories; if it's not
available, it installs the SQLite engine and the R-SQLite
interface under the package directory $R_PACKAGE_DIR/sqlite.
2. If you have SQLite installed in a non-system directory (e.g,
in $HOME/sqlite),
a) You can use
export PKG_LIBS="-L$HOME/sqlite/lib -lsqlite"
export PKG_CPPFLAGS="-I$HOME/sqlite/include"
R CMD INSTALL RSQLite-<version>.tar.gz
b) or you can use the --with-sqlite-dir configuration argument
R CMD INSTALL --configure-args=--with-sqlite-dir=$HOME/sqlite \
RSQLite-<version>.tar.gz
3. If you don't have SQLite but you rather install the version we provide
into a directory different than the RSQLite package, for instance,
$HOME/app/sqlite, use
R CMD INSTALL --configure-args=--enable-sqlite=$HOME/app/sqlite \
RSQLite-<version>.tar.gz
Usage
-----
Note that if you use an *existing* SQLite library that resides in a
non-system directory (e.g., other than /lib, /usr/lib, /usr/local/lib)
you may need to include it in our LD_LIBRARY_PATH, prior to invoking R.
For instance
export LD_LIBRARY_PATH=$HOME/sqlite/lib:$LD_LIBRARY_PATH
R
> library(help=RSQLite)
> library(RSQLite)
(if you use the --enable-sqlite=DIR configuration argument, the SQLite
library is statically linked to the RSQLite R package, and you need
not worry about setting LD_LIBRARY_PATH.)
|