Matthew Jones wrote:
Is there any straight forward way I could use SQLite3 with virtual
tables. By that I mean SQLite contains all the table and index
definitions but none of the data - actually it will contain the data
for some tables but not others. I only need to query access to the
tables so I need to intercept the fetching of data from these virtual
tables & indices. From what I have read in the architecture, it seems
like I want to intercept the btree implementation for these virtual
tables but that doesn't mean it has to be done that way.
Matthew,
See http://www.sqlite.org/cvstrac/wiki?p=VirtualTables for the approach
that is being built into sqlite at this very moment.
Dennis Cote
