Jens Alfke wrote: > I'd like to know which pragmas I need to reissue every time the > database connection is opened, and which I only need to issue when > initializing a new database.
http://stackoverflow.com/documentation/sqlite/5223/pragma-statements/18507/pragmas-with-permanent-effects says the following are permanent: application_id journal_mode (when enabling or disabling WAL mode) schema_version user_version wal_checkpoint and these need to be set before creating the database: auto_vacuum encoding legacy_file_format page_size Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
