Re: [sqlite] [EXTERNAL] Virtual Tables xConnect Called When?

2019-07-25 Thread Richard Hipp
xConnect is called whenever SQLite rereads and reparses the database schema, such as when opening a connection to an existing database. On 7/25/19, Justin Olbrantz wrote: > The reason I asked the question is because for my virtual table which has a > "backing store" (more precisely it needs to

Re: [sqlite] [EXTERNAL] Virtual Tables xConnect Called When?

2019-07-25 Thread Justin Olbrantz
The reason I asked the question is because for my virtual table which has a "backing store" (more precisely it needs to have CREATE VIRTUAL TABLE called to associate a loaded file with the table to be created via a table parameter), I have separate implementations for xCreate and xConnect. xCreate

Re: [sqlite] [EXTERNAL] Virtual Tables xConnect Called When?

2019-07-25 Thread Hick Gunter
This assumes that there is some kind of backing store that needs to be created once (xCreate) but may be conncted to (xConnect) later. CREATE VIRTUAL TABLE calls the xCreate function (and DROP TABLE will call xDestroy), whereas queries will call the xConnect function. IIRC connecting to an