Instead of polling from a custom program, what would be nice is a feature within shell.c that permits the user to specify pre-execute SQL which optionally executes silently before every statement sent through the input line. Testing SCHEMA_VERSION for changes as you suggest (and many other useful refresh type operations) could then be implemented without need of custom application development.
Such a feature would simplify CPU efficient integration of a more lively and au courant command line as other processes change the database. A post-execute SQL feature in shell.c would also have many live integration uses. On Wed, Sep 20, 2017 at 11:25 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 20 Sep 2017, at 6:55pm, petern <peter.nichvolo...@gmail.com> wrote: > > > OK. If system table triggers are generally not maintained, what is > > simplest recommended way, by C API or other means, for the application to > > be notified of non-specific schema changes that include creation/deletion > > events? > > https://sqlite.org/pragma.html#pragma_schema_version > > Keep checking that and do something when it changes. > > Simon. > _______________________________________________ > 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