SQLite Forum

Coming Soon: SQLite Version 3.34
Login

Coming Soon: SQLite Version 3.34

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

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

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 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.)

(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 [link] [source]

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] [source]

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 are more accessible now. The current syntax diagram of SELECT is presented like the following, using NVDA:

graphic syntax diagram select-stmt

With pikchr, the syntax diagram looks like this:

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

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

The idea of hyperlinks in Pikchr has been discussed before on the Pikchr forum. 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.