[R] sqlite and r

Wensui Liu liuwensui at gmail.com
Sun Apr 18 18:52:33 CEST 2010

thanks so much for your reply, Gabor!
actually, my intention is to rsqlite to submit sql into sqlite db from
r and utilize temp tables in sqlite to store the working tables. in
this way, there is not much computing burden and memory consumption in
however, the functions natively supported in sqlite are so limited and
sometimes the data is needed to transferred between r and sqlite back
and forth to get the final job done.

again, appreciate your help, Gabor. by the way, i really like your
sqldf package, wonderful work!

On Sat, Apr 17, 2010 at 8:15 PM, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
> 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:
> http://code.google.com/p/sqldf/#3._Why_does_sqldf("select_var(x)_from_DF")_not_work?
> 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:
> http://sqldf.googlecode.com
> 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.

WenSui Liu
Blog   : statcompute.spaces.live.com
Tough Times Never Last. But Tough People Do.  - Robert Schuller

More information about the R-help mailing list