Fossil

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

About branch deltify-tkt-blobs

The purpose of the deltify-tkt-blobs branch is to improve handling of tickets with long text fields. This topic was initially brought up in the forum post "RFC: Better machinery for tickets with elaborated description".

The primary motivating example is a TICKET table with description column, accompanied by customized /tktnew, /tktview and /tktedit pages, that let a user to make arbitrary edits to ticket's description. A TICKET table may have several such columns, but for brevity any of such columns will be denoted as Description in the following.

For such ticket schema this branch brings-in three improvements:

  1. Deltification of artifacts that hold edits of a ticket's Description, which enables more compact storage (and thus reduces disk usage).
    See check-ins 0f4a0fe82a, c3e7ed3089

  2. Improvement to the /tkthistory page: when appropriate, changes to the Description fields are rendered as unified diffs.
    See check-ins b75a9d0fa3, b2049d643b

  3. Resolving an issue with redundant back-references originating from outdated/superseded values within TICKET table. See check-ins 668e45baff, 4d5ded5eea and forum thread a6ba08e926.

How to use it

Items 1 and 2 from the above are "opt-in" features. These are activated only when a TICKET table contains a phony INTEGER column "baseline for $name", where $name stands for the name of the actual column provisioned for the aforementioned frequently changing text (e.g. "description"). This phony column "baseline for $name" is used for internal bookkeeping and must not be used by the user.

Also in this branch

Check-in 4bb91f38a8 adds id attributes to the list items on the /tkthistory pages, and check-in 7afd4db3d3 adds highlighting to the list item that is being navigated to.

Check-in 2d0b2bda87dd fixes a missing </li>, and check-in 0dd5451d7f53 removes redundant PRE tags on the /wdiff pages.

19 check-ins related to "deltify-tkt-blobs"
2022-10-28
17:08
Improve correctness, usability and efficiency for the case when values in a TICKET's column tend to be long and volatile. Owner of a repository may specify one or several TICKET's columns so that delta-compression is tried for the corresponding ticket change artifacts and the corresponding changes on the <tt>/tkthistory</tt> page are rendered via unified diffs. See details in the [/wiki?name=branch/deltify-tkt-blobs&p|associated wiki]. ... (check-in: 872a3b2327 user: george tags: trunk)
16:28
Add comments for auxiliary local variables inside <code>ticket_output_change_artifact()</code>. ... (Closed-Leaf check-in: 53b66cf63f user: george tags: deltify-tkt-blobs)
06:51
Typo fix in changes.wiki. ... (check-in: 141793c4ab user: stephan tags: deltify-tkt-blobs)
06:37
Merge trunk into deltify-tkt-blobs branch. ... (check-in: 86916df534 user: stephan tags: deltify-tkt-blobs)
00:18
Fix a typo in a comment. ... (check-in: a2ed111979 user: george tags: deltify-tkt-blobs)
00:11
Add more comments and a changelog item. No code changes. ... (check-in: e690df08f4 user: george tags: deltify-tkt-blobs)
2022-10-27
17:56
The check for whether to continue during sync due to outstanding "uvgimme" requests was being skipped in clone -u mode due to misordered tests at the end of the client side of the sync protocol. ... (check-in: 52648d0384 user: wyoung tags: trunk)
2022-10-16
00:09
Highlight a ticket's change that corresponds to the URL's fragment of the <tt>/tkthistory</tt> page. ... (check-in: 7afd4db3d3 user: george tags: deltify-tkt-blobs)
2022-10-09
22:56
Rework the previous check-in to fix incorrect backlinks' sources for the case when values are appended to a field (i.e. a value of J-card starts with '+'). Consider a reference to 77ab05a0e9 from [caeb7d672df20] for an example which was handled incorrectly by [668e45baff99]. ... (check-in: 4d5ded5eea user: george tags: deltify-tkt-blobs)
2022-10-03
01:41
Fix redundant back-references originating from outdated/superseded values within TICKET table. See forum thread [forum:/forumthread/a6ba08e926a8cfdf|a6ba08e926]. ... (check-in: 668e45baff user: george tags: deltify-tkt-blobs)
01:31
Fix naming of columns on the [/test-backlinks] page. ... (check-in: 6a5604f481 user: george tags: deltify-tkt-blobs)
2022-09-20
14:13
On the [/help?cmd=/tkthistory|/tkthistory page] supply each ticket change item with a corresponding id attribute and make the 'History' button within a submenu of a [/help?cmd=/tinfo|/tinfo page] to link back to that particular element on the <code>/tkthistory</code> page. ... (check-in: 4bb91f38a8 user: george tags: deltify-tkt-blobs)
13:56
Minor optimization and refactoring. ... (check-in: b2049d643b user: george tags: deltify-tkt-blobs)
2022-09-15
13:40
Improve <code>/tkthistory</code> page: render selected ticket fields as unified diffs. ... (check-in: b75a9d0fa3 user: george tags: deltify-tkt-blobs)
2022-09-14
13:12
Remove redundant PRE tags on the <code>/wdiff</code> pages. ... (check-in: 0dd5451d7f user: george tags: deltify-tkt-blobs)
2022-08-29
14:27
Add a missing closing LI tag for the /tkthistory page. ... (check-in: 2d0b2bda87 user: george tags: deltify-tkt-blobs)
14:03
Minor optimization within <code>getAllTicketFields()</code> function. ... (check-in: c3e7ed3089 user: george tags: deltify-tkt-blobs)
2022-08-22
18:27
Make it possible to store similar ticket change artifacts as deltas. This might be useful when a certain column of the <var>TICKET</var> table holds a lengthy text that may undergo frequent modifications. This is an opt-in feature. It is activated only when <var>TICKET</var> table contains a phony <code>INTEGER</code> column <code>"baseline for $name"</code> where <code>$name</code> stands for the name of the actual column provisioned for the aforementioned frequently changing text. ... (check-in: 0f4a0fe82a user: george tags: deltify-tkt-blobs)
2022-08-18
13:21
Add the "Timeline" submenu link on the setup_edit page, for ordinary users. Change the "Access Log" link on that same page so that it is only present for ordinary users - not special users like "reader" or "developer". ... (check-in: 6f70a236ce user: drh tags: trunk)