On 4/12/17, David Raymond wrote:
>
> When I open a connection, what's
> the best way to ensure I've connected to an existing file, and am not about
> to create a brand new one by trying to find out?
Use sqlite3_open_v2() to create the database connection and make sure
...@mailinglists.sqlite.org] On
Behalf Of Richard Hipp
Sent: Wednesday, April 12, 2017 3:53 PM
To: SQLite mailing list
Subject: Re: [sqlite] Ambiguity in 'pragma page_size' docs
On 4/12/17, Jens Alfke <j...@mooseyard.com> wrote:
> The docs[1] say that:
>
>> The page_size pragma will only se
> On Apr 12, 2017, at 12:53 PM, Richard Hipp wrote:
>
> The implication *should* be that you *never* change the page size.
> SQLite will pick a good page size for you automatically, which works
> in 99.99% of all cases.
… provided you're running 3.12 or later. Prior to that it
On 4/12/17, Jens Alfke wrote:
> The docs[1] say that:
>
>> The page_size pragma will only set in the page size if it is issued before
>> any other SQL statements that cause I/O against the database file.
>
> It's not stated explicitly, but I believe the pragma has to be issued
The docs[1] say that:
> The page_size pragma will only set in the page size if it is issued before
> any other SQL statements that cause I/O against the database file.
It's not stated explicitly, but I believe the pragma has to be issued before
any other statement _ever_ causes I/O, i.e. it
5 matches
Mail list logo