Re: [R] HOW to install RSQLite database

From: vijaysheegi <vijay.sheegi_at_gmail.com>
Date: Sat, 12 Jun 2010 23:38:18 -0700 (PDT)

Yes i am asking how to install RSQLite packagein windows.Please help on this regards

On 6/11/10, david.jessop [via R] <
ml-node+2251498-1601505055-288333_at_n4.nabble.com<ml-node%2B2251498-1601505055-288333_at_n4.nabble.com>> wrote:
>
> 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: [hidden email]<http://user/SendEmail.jtp?type=node&node=2251498&i=0>[mailto:[hidden
> email] <http://user/SendEmail.jtp?type=node&node=2251498&i=1>]
> On Behalf Of vijaysheegi
> Sent: 10 June 2010 16:22
> To: [hidden email] <http://user/SendEmail.jtp?type=node&node=2251498&i=2>
> 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 <http://www.sqlite.org/?by-user=t>.)
>
> 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<http://r.789695.n4.nabble.com/HOW-to-install-RSQLite-database-tp2250604p?by-user=t>
> 2250604.html
> Sent from the R help mailing list archive at Nabble.com.
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [hidden email] <http://user/SendEmail.jtp?type=node&node=2251498&i=3>mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html<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}}
>
> ______________________________________________
> [hidden email] <http://user/SendEmail.jtp?type=node&node=2251498&i=4>mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
>
> ------------------------------
> View message @
> http://r.789695.n4.nabble.com/HOW-to-install-RSQLite-database-tp2250604p2251498.html
> To unsubscribe from HOW to install RSQLite database, click here< (link removed) =>.
>
>
>

-- 
vijayamahantesh

-- 
View this message in context: http://r.789695.n4.nabble.com/HOW-to-install-RSQLite-database-tp2250604p2253249.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 Sun 13 Jun 2010 - 06:53:03 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 Sun 13 Jun 2010 - 19:50:31 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