[R] sqlite and r
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
> 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