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