Are you asking how to install the RSQLite package or how to create a
SQLite database? The two are somewhat distinct questions. RSQLite is
just a package of functions for R to be able to access data in an SQLite
database. There isn't a separate SQLite program - just a library that is
compiled into RSQLite.
Regards
David
-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
On Behalf Of vijaysheegi
Sent: 10 June 2010 16:22
To: r-help at r-project.org
Subject: [R] HOW to install RSQLite database
Please let me know where i have to type below thing to RSQLite database
get installed.Please let me know the solution.Thanks in advance
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-.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-.tar.gz
b) or you can use the --with-sqlite-dir configuration argument
R CMD INSTALL --configure-args=--with-sqlite-dir=$HOME/sqlite \
RSQLite-.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-.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.)
--
View this message in context:
http://r.789695.n4.nabble.com/HOW-to-install-RSQLite-database-tp2250604p
2250604.html
Sent from the R help mailing list archive at Nabble.com.
[[alternative HTML version deleted]]
______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Issued by UBS AG or affiliates to professional investors...{{dropped:30}}