Coming Soon: SQLite Version 3.34

(1) By Richard Hipp (drh) on 2020-11-23 15:42:36 [link]

The anticipated release date for [SQLite Version 3.34][1] is 2020-12-04,
one week from Friday.

  *  [Change summary][1]
  *  [Updated documentation][2]
  *  [Pre-release snapshot][5]
  *  [Commit log][3]
  *  [Release checklist][4]

If you have any issues or concerns with the upcoming release, please report
them as soon as possible.  The release will occur when the [checklist][4]
goes all-green.  (As I write this, nothing has yet been checked off, but if
you try back later you might see some green items.)

[1]: https://sqlite.org/draft/releaselog/3_34_0.html
[2]: https://www.sqlite.org/draft/
[3]: https://www.sqlite.org/src/timeline?p=trunk&bt=version-3.33.0&n=200
[4]: https://www.sqlite.org/src/ext/checklist/3340000/index
[5]: https://www.sqlite.org/download.html

(2.1) Originally by ddevienne with edits by Richard Hipp (drh) on 2020-11-24 11:21:42 from 2.0 in reply to 1

Hi Richard.

The Pikchr-based syntax diagrams now allow selecting text in boxes.

But could they be links, to jump to the appropriate details for that expression/keyword/etc...?

Would avoid having separate textual links after each diagram, thus  
less clutter on these pages, and easier navigation too.

Of course, this may affect accessibility. But screen-readers are aware  
of links, aren't they? And before the images were completely opaque to  
them anyway, so accessibility is likely improved now I suppose.

Just thinking aloud. Not sure whether links in Pikchr were discussed before.

*Edit by drh: correct spelling of "Pikchr"*

(3) By anonymous on 2020-11-24 09:44:02 in reply to 2.0 [link]

Most screen readers can generate a list of all links on a page and have commands to jump from one link to the next. And the syntax diagrams <u>are</u> more accessible now. The current syntax diagram of SELECT is presented like the following, using NVDA:

<pre>
graphic syntax diagram select-stmt
</pre>

With pikchr, the syntax diagram looks like this:

<pre>
WITH
RECURSIVE
common-table-expression
,
SELECT
DISTINCT
result-column
,
ALL
FROM
table-or-subquery
,
...
</pre>

(4) By Richard Hipp (drh) on 2020-11-24 11:24:52 in reply to 2.1 [link]

The idea of hyperlinks in Pikchr has been
[discussed before][1] on the [Pikchr forum][2].
There are technical complications.
Adding hyperlink capability to Pikchr might be a future
enhancement, and room has been left in the language for this
kind of thing.  But it has not yet been a priority.

[1]: https://pikchr.org/home/forumpost/681d390d4d
[2]: https://pikchr.org/home/forum