On Mon, 20 Jul 2015 17:34:06 -0500 Andy Rahn <andy.rahn at gmail.com> wrote:
> I see there is no way to create a temporary virtual table. It depends on how the virtual table is implemented. Your virtual table code xCreate function can create temporal tables, sqlite3 drop them on sqlite3_close() call. Or do you ask about a virtual table extension in particular, like fts3 or rtree? > One idea I had was to create a second, in-memory db and attach that, > then create the virtual table over there. > > Currently I have it working where as soon as I open the db, I use > sqlite_master to find any left over virtual tables from before and > drop them. > > Any other ideas? Modify the code of your virtual table or ask sqlite3 developers if it's one of the virtual tables provided with sqlite3. > - Andy --- --- Eduardo Morras <emorrasg at yahoo.es>
