Re: [sqlite] advice about schema versioning and WAL

Thanks Dan for this information! (For some reason, your reply appears on the mailing list archive, but never found the way of my inbox. I'm replying to my own message) Gwendal > Dan Kennedy wrote: > > "PRAGMA schema_version" should work the same way in WAL mode. The pragma > will read the

Re: [sqlite] advice about schema versioning and WAL

On 12/29/2017 01:28 AM, Gwendal Roué wrote: Hello, Season's greetings to all SQLite fellows! I'm developping a library that would like to keep a "cache" of some information about the database schema. Such information are the columns of a table, its primary key, or its indexes. The purpose

[sqlite] advice about schema versioning and WAL

Hello, Season's greetings to all SQLite fellows! I'm developping a library that would like to keep a "cache" of some information about the database schema. Such information are the columns of a table, its primary key, or its indexes. The purpose of this cache is not really speed, even if it