[sqlite] vsv module documentation

2020-02-08 Thread Keith Medcalf
Simon, I hope you don't mind me sending this to you directly, but what do you think of the following as the VSV documentation: /* ** 2020-02-08 modified by Keith Medcalf who also disclaims all copyright ** on the modifications and hereby places this code in the public domain ** ** This file

Re: [sqlite] Documentation improvement request

2020-02-08 Thread Warren Young
On Feb 8, 2020, at 11:56 AM, Simon Slavin wrote: > > ? I don't know whether this can be done automatically. Possibly for any > page which has section headers. Yes, it can be done, and I’ve lined out several options for doing so here: https://www.fossil-scm.org/forum/forumpost/a5e1391eb3

[sqlite] Documentation improvement request

2020-02-08 Thread Simon Slavin
Some pages in the documentation started small but had stuff gradually added to them over the years. For the pages can a "Table Of Contents" be added at the top, like the one on

Re: [sqlite] SqlLite.Net: Tables creation and schema changes strategies

2020-02-08 Thread Simon Slavin
On 8 Feb 2020, at 6:25pm, Andy KU7T wrote: > IF isnull(version) THEN > -- create table, indexes etc. > > ELSE > -- make incremental changes > > END IF You're going to have to give up the idea that you can do all this in one complicated SQL command. You're going to end up doing a lot of 1)

Re: [sqlite] SqlLite.Net: Tables creation and schema changes strategies

2020-02-08 Thread Andy KU7T
Ok, your reasoning sounds good. I am struggling to come up with a SQL statement that runs a few expressions conditionally by a book expression. Can you help me get going? Something like: IF isnull(version) THEN -- create table, indexes etc. ELSE -- make incremental changes END IF I'm

Re: [sqlite] SqlLite.Net: Tables creation and schema changes strategies

2020-02-08 Thread Simon Slavin
On 8 Feb 2020, at 3:10pm, Andy KU7T wrote: > I'm looking for best practices on when and where to create/initialize your > tables when using SqlLite.Net as well as how to properly handle schema > changes from one version to another. I urge you not to use CreateTable, but instead to use SQL

[sqlite] SqlLite.Net: Tables creation and schema changes strategies

2020-02-08 Thread Andy KU7T
Hello, I'm looking for best practices on when and where to create/initialize your tables when using SqlLite.Net as well as how to properly handle schema changes from one version to another. It seems I could roll my own using large SQL files or use some library that can do the updates for me…

[sqlite] gmane.comp.db.sqlite.general

2020-02-08 Thread Wolfgang Enzinger
Hi, for those of us who - like me - prefer to access this mailing list via NNTP: the Newsserver's address has changed from news.gmane.org to news.gmane.io (sorry if this is old news; I couldn't find any information about that here.) Wolfgang ___

Re: [sqlite] case-insensitivity of keywords are hardly documented

2020-02-08 Thread Jean-Luc Hainaut
On 7/02/2020 20:08, Aapo Rantalainen wrote: Hi, I'm just doing some 'software archeology' and I found that: on Nov 21 01:02:00 2004 FossilOrigin-Name: ac72a1d5518f7b505ae2a1bd3be3d71db461ae7e git: f8565825622a1ed48bdaa835968a1137b2ffa593 This sentence have been dropped out of documentation: