Andrew Piskorski wrote:
As an R user, I'm happy to see the project below, it could become a
very handy use of SQLite.
I suspect it's well out of scope for that project, but it would be
particularly cool to eventually see some of the integration go the
other way, and allow use of SQLite's SQL engine to manipulate R data
frames (which are tables, basically) from within R, as that would be
much more powerful than R's rather limited set of data frame
manipulation functions.
You might want to take a look at DRH's proposal,
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
which looks like it would make it easier for the R community to
implement the sort of interface you're talking about.
