Stack Overflow
Stack Overflow

Questions tagged [fts3]

FTS3 and FTS4 are SQLite virtual table modules that allow users to perform full-text searches on a set of documents.

The most common (and effective) way to describe full-text searches is "what Google, Yahoo and Altavista do with documents placed on the World Wide Web". Users input a term, or series of terms, perhaps connected by a binary operator or grouped together into a phrase, and the full-text query system finds the set of documents that best matches those terms considering the operators and groupings the user has specified.

135 questions
0
votes
1 answer

How to set a 'DEFAULT' field when using fts3 Sqlite table?

I'm trying to set a default field in my table to current time. When I use a fts3 virtual table, inserting a row doesn't fill the default field to what it should be. Instead, it inserts null. If I create the same table as normal table, the exact…
Onur Yıldırım
  • 355
  • 1
  • 2
  • 10
0
votes
1 answer

Unable to create virtual table in sqlite3 in electron app

I am using my own sqlite3.dll in electron. So i need to register all the functions of sqlite3 with 'ffi' that I need to use. It was working pretty well till now. Ex for sqlite3_exec, i've registered this in ffi as follows var lib =…
Ishwar Rimal
  • 1,071
  • 11
  • 19
0
votes
0 answers

SQLite: migration from FTS3 to FTS4

I have some project with SQLite database that already uses FTS3 extension. Say I want to use FTS4 instead. What has to be done for that? Is there need to create new tables, repopulate or anything else? Or just change word 'fts3' to 'fts4' is…
BorisV
  • 683
  • 3
  • 20
0
votes
1 answer

SQLite, text search FTS etc

I am doing some updates and repairs on some old D5 business stuff (freebie for friend) with SQLite3 so have to use Zeos 6.6 I would like to speed up a text search which currently uses two BLOB_TEXT Fields, "Class" and "Methods" if…
user2175495
0
votes
2 answers

Work around of Android SQLite full-text search for Asian text

I have read about many posts asking whether the SQLite based full-text search can be done in Android, and all the answers point out that the built-in SQLite of Android does not allow custom tokenizer. The default tokenizer considers the words…
Gordon Liang
  • 348
  • 2
  • 11
0
votes
1 answer

Combine MATCH with OR clause in the WHERE statement

I want to perform a query in which the WHERE clausule has the following condition: one MATCH condition over a column in a FTS3 table OR another not MATCH condition over a column in a non FTS table. Example: Say that I have two tables books_fts,…
GaRRaPeTa
  • 5,459
  • 4
  • 37
  • 61
0
votes
1 answer

Getting no such module: fts error in corona with sqlite

I am trying to run a "match" query against a sqlite database from inside a corona app. I compiled the sqlite database from the source files using cl.exe and when I compiled I included the flags to enable the fts features. Then I created a virtual…
user2026318
  • 173
  • 1
  • 13
0
votes
1 answer

How can I populate an fts virtual table with the content from an regular table?

I've just discovered the possibility to use an virtual table for searching thru database content. I have however been sitting with this for two days now, and I think I'm getting stupider for every hour that pass. Can someone please provide me with…
The Dude
  • 1,088
  • 7
  • 16
  • 30
0
votes
1 answer

How best to import multiple text files into SQLite FTS virtual table?

I have multiple text files that I would like to import into a virtual FTS table in SQLite. The documentation here mentions inserting ~500,000 files from the Enron email dataset into a single table. I do not understand how this was done. Oreilly here…
pablo honee
  • 105
  • 1
  • 7
0
votes
1 answer

How do I query an fts table in sqlite for one column matching and another NOT matching a particular query?

I have a Suggestions table(FTS4) that is used to provide suggestions for a query in Android action bar search. I need to query the table for suggestions where one column(suggest_text_1) matches the query text AND another column(data_type) does NOT…
Vinay S Shenoy
  • 4,028
  • 3
  • 31
  • 36
0
votes
1 answer

FTS3 setup on Windows

I am trying to use FTS3 in SQLite. The virtual table is created using sqlitebrowser_200_b1_win. CREATE VIRTUAL TABLE tbl1 USING FTS3 ( col1 TEXT, col2 TEXT); When I insert some data it says: no such module FTS3 insert into tbl1(col1, col2) values…
user3281006
  • 1
0
votes
1 answer

Verifying sqlite FTS (Full Text Search) syntax, and how to do a single term NOT search

Is there a way to determine if a MATCH query sent to an fts3 table in sqlite is valid? Currently, I don't find out if the expression is invalid until I try to run it, which makes it a little tricky. I'd like to report to the user that the syntax is…
Snazzer
  • 7,704
  • 5
  • 27
  • 25
0
votes
1 answer

Get All rows from virtual table when no query

I need to know if it's possible to get all rows from fts table when user doesn't type any text. I need this, because when app starts, I need to show all rows. How can I achieve this?
vitorvigano
  • 697
  • 2
  • 8
  • 18
0
votes
1 answer

binding selectionArgs to a FTS3 query that spans across multiple columns

I construct selection string to perform FTS3 search across multiple columns: final String selection = "table MATCH 'column1:? OR column2:?'" I am also passing selectionArgs containing the search terms. The problem is that I'm getting an exception…
Y2i
  • 3,748
  • 2
  • 28
  • 32
0
votes
1 answer

Match 3 or more values in FTS table

I have 2 FTS tables:search and search_eng. I am trying to get entry_id of matched word from search_eng. Then I take values from search according to those entry_id. But when I tried implement that in the way which was shown below it is giving…
Joe Richard
  • 1,520
  • 7
  • 20
  • 31
1 2 3
…
8
9