On 1 Jun 2019, at 9:54pm, Sam Carleton <scarle...@miltonstreet.com> wrote:
> What is the best way to ensure that these two features are set correctly? > Does the program simply need to make sure it issues the pragma after each > connection, assuming it is always new? The simplest way is what you say: execute those two PRAGMA commands immediately after you open the file. It's never a problem to set those settings even if that's the way things are already set. You should also make sure you have set a timeout, whether in the connection string or as a third PRAGMA. In fact setting a timeout is what we normally get this question about. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users