[sqlite] julian qian wants to stay in touch on LinkedIn

LinkedIn General, I'd like to add you to my professional network on LinkedIn. - julian qian Confirm that you know julian qian https://www.linkedin.com/e/isd/1028285185/9hLDvOAo/ -- (c) 2010, LinkedIn Corporation

Re: [sqlite] call PRAGMA page_size twice?

it is a test case for the this PRAGMA... in reality, yes, just one call is good enough. On Tue, Apr 21, 2009 at 12:37 PM, John Machin <sjmac...@lexicon.net> wrote: > On 21/04/2009 2:07 PM, julian qian wrote: >> HI, >> call PRAGMA page_size =xxx twice immediately, only first

[sqlite] call PRAGMA page_size twice?

HI, call PRAGMA page_size =xxx twice immediately, only first time it has effect, immediately call it second times, the value can't be changed. is this predefined? http://www.sqlite.org/pragma.html#pragma_page_size only say "The page_size pragma will only cause an immediate change in the page size

[sqlite] sqlite 4 bytes write

I would like us to understand the write patterns of Sqlite. . That write pattern happens first to the journal then to the database. I found a lot of 4 byte writes. What are these 4 byte writes and can the be avoided? I would also like data on the write patterns for a 1k,2k,128k, and 256k writes

[sqlite] sqlite3_step returns SQLITE_OK

** In the legacy interface, the return value will be either [SQLITE_BUSY], ** [SQLITE_DONE], [SQLITE_ROW], [SQLITE_ERROR], or [SQLITE_MISUSE]. ** With the "v2" interface, any of the other [SQLITE_OK | result code] ** or [SQLITE_IOERR_READ | extended result code] might be returned as ** well. the

[sqlite] upgrade from sqlite 2.8.11 to sqlite3?

Hi everyone. I am thinking about upgrading sqlite version, and I found lots of things changed in sqlite3, for example, sqliteBtreeUpdateMeta(Btree *pBt, int *aMeta) changed to sqlite3BtreeUpdateMeta(Btree *p, int idx, u32 iMeta), What should I put in idx and iMeta? and old code require call