On 20 Sep 2017, at 10:10pm, petern <[email protected]> wrote:
> 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. shell.c is part of the command-line shell. It’s intended for testing, and for people who can’t write software. Since you understand the sort of things you understand, you shouldn’t be using it in a production setting. I’m going to dismiss this and tell you how to do it in your own software instead. If you want to check the statements your own program is executing then you can use an authorizer. <https://sqlite.org/c3ref/set_authorizer.html> and check for certain action codes: <https://sqlite.org/c3ref/c_alter_table.html> This will tell you in some detail what kind of schema chance it taking place. Or you can instead just check the code to see if it means a change to the schema. Note that this covers only operations performed via your own connection, i.e. by that same program running on that same computer. It cannot tell you what other programs accessing the same database are doing. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
