[R] sqlite and r

Gabor Grothendieck ggrothendieck at gmail.com
Sun Apr 18 02:15:49 CEST 2010

1. There is no off the shelf facility although SQLite itself allows
you to write C functions and those presumably could call R but you
would have to do it yourself.

2. There are also some solutions discussed here which might be good
enough and are a lot easier than #1:

3. Also you could use a different database.   For example, sqldf also
allows you to use H2 or PostgreSQL in place of SQLite and they have
many more functions than SQLite.   See:

On Sat, Apr 17, 2010 at 8:04 PM, Wensui Liu <liuwensui at gmail.com> wrote:
> have used both for a while and feel they are like pea and carrot together.
> it is extremely handy to use sqlite engine for heavy data management
> from r instead of using r directly.
> i am also wondering  if i could define and register sqlite functions
> within r in the way similar to how we do in python. if this is doable
> in r, that will be perfect. any insight?
> ______________________________________________
> 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.

More information about the R-help mailing list