On Sun, Apr 17, 2011 at 3:36 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: >> Is there any way to persistently set certain PRAGMAs, so that they >> need not be set every time a DB handle is opened? > > Many PRAGMA default valuess can be influenced using compiler flags > SQLITE_DEFAULT_* .
I was mildly aware of those, but those are not good enough. Suppose I have an application using a SQLite3 DB that requires extensive setup at DB open time (set non-persistent pragmas, create temp triggers, ...). Well, such a DB cannot safely be handled via the sqlite3 shell. Now, it's true that that's expected, but if all the application "business" logic can be encoded in table constraints, indexes and triggers, then it ought to be possible to make it safe to access via the shell, and _that_'s what I'm looking for. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
