Stack Overflow
Stack Overflow

Questions tagged [fts5]

FTS5 is an SQLite virtual table module that provides full-text search functionality to database applications. In their most elementary form, full-text search engines allow the user to efficiently search a large collection of documents for the subset that contain one or more instances of a search term. The search functionality provided to world wide web users by Google is, among other things, a full-text search engine, as it allows users to search for all documents on the web that contain, for example, the term "fts5".

For more information, refer here

48 questions
0
votes
1 answer

How to search a substring using FTS5 in SQLite

Suppose I have created a virtual table using FTS5 module in SQLite 3.35 like this: CREATE VIRTUAL TABLE TrialFTS USING fts5(search); I have prepopulated the table with data. Now to search any row that contains the phrase 'Black', I can search…
Sayansen
  • 51
  • 1
  • 8
0
votes
1 answer

Why is this sqlite3 FTS5 contentless table not searchable?

If I understand correctly, the purpose of a FTS5 contentless table is to only store indexing data, and not store the text itself, in order to save storage space. Something seems wrong with the following contentless table, because is NOT searchable…
Max L.
  • 9,774
  • 15
  • 56
  • 86
0
votes
1 answer

Lossless SQLite FTS5 search of a substring

Using a FTS5 virtual table returns nothing for postfix searches. It only can search for the entire word tokens, or for the prefixes of the word tokens if I append * to the search. For example, it does not find qwerty.png row, if I search for…
KeyKi
  • 2,693
  • 3
  • 12
  • 24
0
votes
1 answer

SQLite: FTS5 'delete'd row still appears in MATCH results

I have a table: CREATE TABLE Tests (col1 INTEGER, col2 INTEGER, col3 INTEGER, col4 INTEGER, col5 INTEGER); with values: INSERT INTO Tests (col1, col2, col3, col4, col5) VALUES (1, 2, 3, 4, 5); INSERT INTO Tests (col1, col2, col3, col4, col5) VALUES…
user19610681
0
votes
1 answer

How do I use the snippet() function using a FTS5 virtual table in SQLite?

In the SQLite documentation for FTS5 it is claimed that 5 parameters must be passed to the snippet function: The snippet() function is similar to highlight(), except that instead of returning entire column values, it automatically selects and…
John T
  • 814
  • 10
  • 17
0
votes
0 answers

can I search two sqlite fts5 index's across two tables?

I have a tasks application with two tables. One table has the task name, date, owner etc and the other has the comments for the task linked to the task number so there can be multiple comments attached to a single task. Both tables have FTS5…
mrbc42
  • 1
  • 1
0
votes
2 answers

How can I resolve fts5 error after I upgraded Wagtail

I have upgraded my Wagtail installation to 2.15.1 with Django 3.1.13 When I run manage.py migrate I get an error django.db.utils.OperationalError: no such module: fts5 I have searched but cannot find any solutions to this problem Can someone…
Psionman
  • 3,084
  • 1
  • 32
  • 65
0
votes
1 answer

How do I use the trigram tokenizer/similarity option with Peewee and SQLite's FTS5?

This question concerns how to use FTS5's trigram tokenizer with Peewee. The official FTS5 documentation for SQLite cites support for trigram tokenization/similarity: > The experimental trigram tokenizer extends FTS5 to > support substring…
xax
  • 2,043
  • 4
  • 24
  • 28
0
votes
0 answers

How does full-text search snowball algorithm interpret words of an unspecified language

I build a full-ext search index with sqlite and don't understand what is going on internally when i'm scanning documents contain few languages. For example, i describe a programming topic i'm learning in Russian and add into the description code…
kvdm.dev
  • 141
  • 1
  • 1
  • 12
0
votes
1 answer

SQLite custom functions as match string

I create a SQLite function which takes a string and returns another string, then I can use the return value as match strings. Code is here It works very well except for the single quotes. In this case, it can't match any rows, but if I directly use…
Fenjin Wang
  • 331
  • 2
  • 12
0
votes
1 answer

SQLite:fts5 and rank, sort by date

We're using SQLite and FTS5 in our appliction. It's working well and is extremely fast. However, we have hit a problem when our virtual fts table grows large. We need to sort our search results by date in reverse chronological order and not by the…
Mise
  • 59
  • 5
0
votes
1 answer

Is there a way to see the result of applying arguments to a query in sqlite?

I'm using sqlite3 in Go and for debugging purposes would like to see the result of applying arguments to the query with the replacements, i.e., with ? replaced by the actual argument. Is this possible? Currently, I have code like the following and…
Eric '3ToedSloth'
  • 332
  • 1
  • 9
0
votes
0 answers

Sqlite FTS minimal token size

How to tell Sqlite FTS5 to only index tokens over a certain length ? The 'prefix=n' option is close but serves prefix-indexing. The 'tokenize' options don't seem to offer this. CREATE VIRTUAL TABLE words USING fts5 ( title ,content =…
alco
  • 1
  • 1
0
votes
0 answers

SQL Statement works in SQLiteManager, but not in my program

I am trying to take relevant values from an existing table and put them into a Virtual table, which I can then search through and get the entries I want. I have everything more or less working except the actual loading of the entries into this…
Samuel Ludwig
  • 111
  • 1
  • 7
0
votes
2 answers

How to FTS-match from 2 different columns

I am trying to search 2 separate columns called keyword and keyword2 for a match. Can this be done with SQLite FTS? I've tried this statement but it did not work: String sql = "Select * from tblvHAL2001 WHERE tblvHAL2001 MATCH 'keyword:" + question…
maximdj
  • 315
  • 1
  • 12
1 2
3
4