[R] HOW to install RSQLite database

From: vijaysheegi <vijay.sheegi_at_gmail.com>
Date: Thu, 10 Jun 2010 08:22:23 -0700 (PDT)

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),    

  1. 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-tp2250604p2250604.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.
Received on Thu 10 Jun 2010 - 16:11:18 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 11 Jun 2010 - 09:40:29 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive