> > Could there be a way to make shadow tables off-limit to arbitrary SQL?
That is one of the things that the new SQLITE_DBCONFIG_DEFENSIVE option does - it makes shadow tables read-only so that they cannot be corrupted by SQL. However, it is off by default, since some application make use of the ability to write directly into shadow tables. For example, when you restore a database using the output of the ".dump" command, that requires writing directly into shadow tables. -- 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