Eric Bohlman wrote:
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.
Hello all,
I've read the proposed virtualTable schema.
Mr Hipp could you elaborate on how you envision spatial indexing ?
I now construct a in memory quadtree of my spatial structure, so that I
get a set of key when I do a "window query".
I suppose now that I need to create a temporary table of thoses key and
then do a kind of union between this table and my target
geometry+attributes table. How would a virtual table help that process ?
Thank you
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net
