Hi, On Tue, Jun 19, 2018 at 1:56 PM, 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.
Is there a way to get which command was executed? Or which table was added/changed/dropped? Or the only way is to query sqlite_master? But there is no guarantee that the last record in that table with the "'table' || 'view'" condition will be that one that was just created/altered. Thank you. > -- > 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