R help - Apr 2010 - sqlite and r

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?

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.
>

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
r.
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
==============================