But that trigger would be executed in a context of a process modifying the database.
2018-06-20 8:24 GMT+02:00, Peter Johnson <[email protected]>: > 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 <[email protected]> wrote: > >> On 6/19/18, Igor Korot <[email protected]> wrote: >> > Hi, Wout, >> > >> > On Tue, Jun 19, 2018 at 1:31 PM, Wout Mertens <[email protected]> >> > 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 >> [email protected] >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
