Is it possible to create a trigger on sqlite_master which calls a user-defined function AFTER INSERT?
That would avoid having to poll, but it'd still allow the application to be notified when the schema changed. On 19 June 2018 at 20:56, Richard Hipp <d...@sqlite.org> wrote: > On 6/19/18, Igor Korot <ikoro...@gmail.com> wrote: > > Hi, Wout, > > > > On Tue, Jun 19, 2018 at 1:31 PM, Wout Mertens <wout.mert...@gmail.com> > > wrote: > >> you can query the table with > >> https://www.sqlite.org/pragma.html#pragma_table_info > > > > Let me give you a scenario: > > > > 1. My application connects to the database and performs some > > operations (using C API). > > 2. During the application run, someone started sqlite3, connects to > > the database and creates a > > brand new table. > > 3. My application will need to pick up the newly created table and > continue. > > > > Is it easily possible? > > > > There is a sqlite3_*_hook() family of functions, but it looks like > > they won't help with sqlite_master. > > > > Is there a different way? > > Poll the PRAGMA schema_version value and watch for changes. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > 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
