Philippe, with a bit of work you can use the authorize api in order to know when an access to a non existing table is performed. https://sqlite.org/c3ref/set_authorizer.html
Hope this helps. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs > On 17 Mar 2018, at 15:53, Philippe Riand <p...@darwino.com> wrote: > > We are using virtual tables to provide an SQL access to our data set and this > works very well. But we have potentially "a lot” of virtual tables, with > some even yet unknown when we start the DB. We’d like to create them lazily, > on first access. > Is there a hook we can use so when an SQL statement refers to a non existing > table it asks a callback for a VT definition? It is fine if these dynamic > table requires a specific prefix similar to the "temp” one. > > Regards, > > Phil. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users