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 <ggrothendi...@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 <liuwen...@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@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 ============================== ______________________________________________ R-help@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.
