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 sql
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/sql
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
3 matches
Mail list logo
