Hi, ALL,

In the page https://sqlite.org/lang_createindex.html, the syntax diagram is missing the index name.

Thank you.

P.S.: I don't know if the forum accepts the screenshot, but I can make one and put it somewhere...

Works perfectly here. What browser are you using?

Hi,

Works perfectly here. What browser are you using?

I'm on FF on Gentoo Linux.

Where can I put a screenshot for the review?

Thank you.

Seems fine to me. Here's an ASCII rendition of the relevant Pikchr diagram:

...
| 
|-> schema-name -> . ---> index-name -> ON -> ...
|                     |
\---------------------/

Are you seeing something different?

Hi,

Where can I put a screenshot?

Thank you.

yea, sorry about that, but the OP's plea for posting a picture (and my own urge to experiment) proved too strong :)

I tried many different ways and encoding the image as base-64 was the only one that worked. I see (from the markdown docs for the forum) that pikchur embeds are allowed (which is what the original diagram is) but I don't know how to create one. In any case, point well noted.

edit: Would be nice actually to have the ability to post pictures, but we have also managed without it quite well far

edit: Would be nice actually to have the ability to post pictures,

It's definitely a sorely-missed feature by most folks (myself included now and then), but it's one the Fossil devs (primarily myself and drh) have repeatedly actively rejected. Fossil's /chat app supports them, so we're not 100% averse to them, but we're concerned about bandwidth usage, moderation effort, and long-term repository sizes if the general public were able to easily upload arbitrary screenshots.

No harm done, but (everyone!) please, in this forum, don't use that otherwise perfectly legitimate approach to shoehorning in screenshots.

For the record, we discourage...

Also for the record, that's finally been documented in the new FAQ page, reachable via the "About" link at the top of this site.

New suggestions for FAQ entries are welcomed¹, especially if they include links to relevant forum posts and/or SQLite doc pages. Just post them here in the forum.

---

1. ^{^} Keeping in mind that the "F" in FAQ means "frequently" or "repetitively".

I don't know if the forum accepts the screenshot

It does not. That is a deliberate design decision. What I have found is that providing the ability to attach images encourages low-information users to attach hi-res screenshots of their entire desktop and then ask "Why doesn't this work?". And then this Forum is compelled to store those multi-megabyte screenshots for the next 25 years or so. Multiple multi-megabyte images per day begins to add up.

So, no images. Use your words.

If you have access to some other website where you can post your screenshot, you can do so and then include a link in your post. But this Forum does not want to store your screenshot for 25 years.

If you have access to some other website where you can post your screenshot, you can do so and then include a link in your post. But this Forum does not want to store your screenshot for 25 years.

Fwiw, I tried linking to an image on imgur but just couldn't get it to work

That link came through fine. Just don't expect the image to be inlined, as that just encourages others to post their 8K screenshots while asking for help.

Also, I see index-name clearly near the center of the screenshot, so I'm not sure why you're claiming you don't see it.

Also, I see index-name clearly near the center of the screenshot, so I'm not sure why you're claiming you don't see it.

To be clear, the you're above is oneeyeman, not me, the inadvertent experimenter with image-posting. I see the index-name just fine.

Just don't expect the image to be inlined, as that just encourages others to post their 8K screenshots while asking for help.

Also, per the newly minted FAQ, it is perfectly ok to link and inline the image as long as it is hosted somewhere other than sqlite.org servers (or so I understand)

Ah sorry, posting on a bus ride home, not the best place to follow up on a surprisingly long thread. :)

This has always worked for me in the past. Try this markup

You have to link to an individual image, and not an album.

In imgur, simply paste the image in, let it upload, then copy the link. It should link to a PNG

... for the next 25 years or so

Just to add some context for those who might not know: the SQLite project is pledged to be supported through at least its 50th anniversary in 2050. i.e. 25 years from now.