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
-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.
___
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
> 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
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
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
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,
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
8 matches
Mail list logo