Re: [sqlite] Which pragmas are persistent?

2017-04-21 Thread John G
PRAGMA foreign_keys=1 is transient, but it would be nice if it were persistent. John G On 13 April 2017 at 12:35, Tony Papadimitriou wrote: > -Original Message- From: no...@null.net > >> What would be useful (at least via the shell CLI) is a "list_pragmas" >> pragma

Re: [sqlite] Which pragmas are persistent?

2017-04-13 Thread Tony Papadimitriou
-Original Message- From: no...@null.net What would be useful (at least via the shell CLI) is a "list_pragmas" pragma that shows for example something like this: sqlite> PRAGMA list_pragmas; PRAGMA list; would be less redundant. ___

Re: [sqlite] Which pragmas are persistent?

2017-04-13 Thread Clemens Ladisch
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

Re: [sqlite] Which pragmas are persistent?

2017-04-12 Thread Jens Alfke
> On Apr 12, 2017, at 1:01 PM, Simon Slavin wrote: > >> which I only need to issue when initializing a new database. > > 'need' is a bit strong. I have never worried about pagesize in a database. > I’ve always just left it at the default for whatever platform I’m using

Re: [sqlite] Which pragmas are persistent?

2017-04-12 Thread David Raymond
reverse_unordered_selects etc, etc... Please correct me if I messed up. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Wednesday, April 12, 2017 3:29 PM To: SQLite mailing list Subject: [sqlite] Which pragmas are persistent? Many

Re: [sqlite] Which pragmas are persistent?

2017-04-12 Thread Simon Slavin
On 12 Apr 2017, at 8:29pm, Jens Alfke wrote: > which I only need to issue when initializing a new database. 'need' is a bit strong. I have never worried about pagesize in a database. I’ve always just left it at the default for whatever platform I’m using when I create

Re: [sqlite] Which pragmas are persistent?

2017-04-12 Thread Richard Hipp
On 4/12/17, Jens Alfke wrote: > Many of SQLite's pragma commands change database settings. It would be > helpful if their documentation[1] stated which of these persist across > closing/reopening the database, and which are scoped only to the open > connection. For example,

[sqlite] Which pragmas are persistent?

2017-04-12 Thread Jens Alfke
Many of SQLite's pragma commands change database settings. It would be helpful if their documentation[1] stated which of these persist across closing/reopening the database, and which are scoped only to the open connection. For example, the docs say that that 'pragma journal_mode=WAL' is