Re: [sqlite] Doc about sqlite_master

On Mon, Aug 5, 2019 at 2:03 PM Simon Slavin wrote: > On 5 Aug 2019, at 11:54am, Dominique Devienne wrote: > > > What other sqlite_* tables are you talking about? > > sqlite_master is AFAIK the only table with a "fixed-name", that's part > of the "public API" as previously discussed. > > I would

Re: [sqlite] Doc about sqlite_master

On 5 Aug 2019, at 11:54am, Dominique Devienne wrote: > What other sqlite_* tables are you talking about? > > sqlite_master is AFAIK the only table with a "fixed-name", that's part of the > "public API" as previously discussed. I would argue that sqlite_sequence and sqlite_stat?, as documented

Re: [sqlite] Doc about sqlite_master

On Mon, Aug 5, 2019 at 11:37 AM Simon Slavin wrote: > On 5 Aug 2019, at 10:34am, Dominique Devienne wrote: > > > Thus my suggestion that an explicit page of its own is > warranted, properly indexed then. > Given that there are other sqlite_* tables which are documented, perhaps > rather than

Re: [sqlite] Doc about sqlite_master

On 5 Aug 2019, at 10:34am, Dominique Devienne wrote: > Thus my > suggestion that an explicit page of its own is warranted, > properly indexed then. Given that there are other sqlite_* tables which are documented, perhaps rather than having a page on just sqlite_master, there should be a page

Re: [sqlite] Doc about sqlite_master

On Mon, Aug 5, 2019 at 10:37 AM Simon Slavin wrote: > On 5 Aug 2019, at 9:25am, Dominique Devienne wrote: > < > https://www.sqlite.org/fileformat2.html#storage_of_the_sql_database_schema > > > > I think the first of those could be said to be the place to go for

Re: [sqlite] Doc about sqlite_master

On 5 Aug 2019, at 9:25am, Dominique Devienne wrote: > First, is sqlite_master part of the "public API" of SQLite? > I would think so, since many example refer to it. It's documented. Therefore it can't be changed on a whim. So I'd agree that it's part of the public API. The two most

[sqlite] Doc about sqlite_master

First, is sqlite_master part of the "public API" of SQLite? I would think so, since many example refer to it. I was thus looking for a Doc page about it, but a quick Google search didn't turn up a "direct" result. For example, the values sqlite_master.type can take, I found only outside