[sqlite] create temporary virtual table

2015-07-21 Thread Hick Gunter
of SQLite Database Betreff: Re: [sqlite] create temporary virtual table Most types of virtual table can be created as temporary tables with no trouble by specifying the temp database when you create them. IE: CREATE VIRTUAL TABLE temp.myrtree USING RTREE (id,minx,maxx); However, the virtual table

[sqlite] create temporary virtual table

2015-07-21 Thread Eduardo Morras
On Mon, 20 Jul 2015 17:34:06 -0500 Andy Rahn 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

[sqlite] create temporary virtual table

2015-07-21 Thread Peter Aronson
Most types of virtual table can be created as temporary tables with no trouble by specifying the temp database when you create them. ?IE: CREATE VIRTUAL TABLE temp.myrtree USING RTREE (id,minx,maxx); However, the virtual table method xDestroy does not get called for a virtual table in the temp

[sqlite] create temporary virtual table

2015-07-20 Thread Andy Rahn
Awesome! Thanks, I forgot about using the temp. Database. Andy On Monday, July 20, 2015, Peter Aronson wrote: > Most types of virtual table can be created as temporary tables with no > trouble by specifying the temp database when you create them. IE: > CREATE VIRTUAL TABLE temp.myrtree USING

[sqlite] create temporary virtual table

2015-07-20 Thread Andy Rahn
I see there is no way to create a temporary virtual table. 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