[R] HOW to install RSQLite database

[John Kane]

select a cran mirror  > Packages > Select Cran Mirror

In R use  the following command
   install.packages("RSQLite")



--- On Sun, 6/13/10, vijaysheegi <vijay.sheegi at gmail.com> wrote:

> From: vijaysheegi <vijay.sheegi at gmail.com>
> Subject: Re: [R] HOW to install RSQLite database
> To: r-help at r-project.org
> Received: Sunday, June 13, 2010, 2:38 AM
> 
> 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.
>