SQL FTS 5

[DPaul]

earching for documentation about this I came across the duckdb database

Thanks, never heard of it either:
https://duckdb.org/2021/01/25/full-text-search.html
Even mariaDB etc... support FTS5.
Unfortunately the decision which DB to use, is not mine.
Some very learned people will meet and tell me tomorrow (hopefully).

As for the documentation, maybe the fact that FTS5 is relatively unknown,
causes the lack of hands-on examples. First you think something is impossible,
the next day you find out there is a way, resulting in loss of time.
I guess that is part of the learning curve.

e.g. what are the consequences of ... using fts5 (filename,data,register, tokenize='trigram') ...?
Should I define every table with " tokenize='trigram'" when I want to use like. Can I convert existing 'normal' tables ... etc etc..;
Paul

[DPaul]

Hi,
This seems to be a more organised "exposé".
https://runebook.dev/en/docs/sqlite/fts5?
But it copies examples from other sources.

If somebody has the time, what is the difference between LIKE and GLOB ?
As I said before, I got LIKE to work via the trigram extension, it behaves like python's 'if ... in <string>' .
But many things remain vague or "unspoken" about this feature.
Paul

[Gribouillis]

I wonder why they keep saying that the underscore is the codepoint 96. For me it is 95. I think it is an error in the SQLITE documentation

>>> print(chr(95))
_
>>> print(chr(96))
`

[Larz60+]

Where can I find a complete and definitive overview of FTS 5 syntax, compatible with python of course.

Perhaps by searching the References and bibilographies of papers on google scholar, the complete reference to FTS5 can be found, for example, from this list: https://scholar.google.com/scholar?hl=en...+FTS5&btnG=
or from NIST

[DPaul]

Perhaps by searching the References and bibilographies of papers on google schola

Looks interesting!
A lot of stuff though ...
Thanks,
Paul