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-288...@n4.nabble.com<ml-node%2b2251498-1601505055-288...@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@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.
