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
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
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
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
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
5 matches
Mail list logo