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
6
votes
3 answers

Fastest full text search today?

spoiler : This is just another Lucene vs Sphinx vs whatever, I saw that all other threads were almost two years old, so decided to start again.. Here is the requirement : data size : max 10 GB. rows : nearly billions indexing should be…
Shrinath
  • 7,888
  • 13
  • 48
  • 85
6
votes
1 answer

SQLite query for Full Text Search to MATCH on both sides like LIKE

I am having an issue for both side MATCH in SQLite FTS in Android. Say suppose I have this text item in my VIRTUAL FTS TABLE Hello World I am here HelloWorld I am Here HelloWorldIamHere I want to achieve that for Search String 'World' I should get…
kanudo
  • 2,119
  • 1
  • 17
  • 33
6
votes
3 answers

Sqlite FTS, Using OR between match operators

When I execute the following query in a sqlite engine (android or sqlitebrowser) it throws an exception that says unable to use function MATCH in the requested context. select a.Body1, b.Body2 from tbl1_fts as a, tbl2_fts as…
Mohi
  • 1,776
  • 1
  • 26
  • 39
6
votes
1 answer

SQLite FTS3 simulate LIKE somestring%

I'm writing a dictionary app and need to do the usual word suggesting while typing. LIKE somestring% is rather slow (~1300ms on a ~100k row table) so I've turned to FTS3. Problem is, I haven't found a sane way to search from the beginning of a…
yanchenko
  • 56,576
  • 33
  • 147
  • 165
5
votes
0 answers

React Native SQLite Full Text Search

I'm trying to implement full-text search with SQLite in React Native. I'm using react-native-sqlite-storage. Android doesn't support FTS5. But, I've been able to create a virtual table and run queries using FTS4. The problem is ranking the search…
ataravati
  • 8,891
  • 9
  • 57
  • 89
5
votes
0 answers

Search the entire SQLite database using FTS3/FTS4?

I have a sqlite database which contains lots of html content which I display using a webview. Now I want to add search functionality into my app. I have two tables one for categories and the other for subcategories. Followings are the create…
AndroidNewBee
  • 744
  • 3
  • 12
  • 36
5
votes
2 answers

Android SQLite fts3: What should I insert: null values OR empty strings?

I've created a SQLite FTS3 table for an Android app with several columns. The table is populated by user's inputs. However not all table columns should have a value. Example: There is a column named PLURAL. The user submits a word which is a verb…
kkats
  • 69
  • 1
  • 7
5
votes
1 answer

Detect the FTS3 extension in SQLite3

What is the SQLite query to detect if the FTS3 extension module is installed? Or is it possible to get a list of installed extensions with an SQLite3 query? It has to work with pysqlite2. I know that I can get the list of tables using SELECT * FROM…
pts
  • 80,836
  • 20
  • 110
  • 183
5
votes
1 answer

How can I create a trigger between normal table and fts3 table?

I have been having issues switching between FTS3 tables and normal database tables. My application is very simple and allows the user to add contacts to a database and they can search for contacts that match the search query (why i used a fts table)…
Sai Valluri
  • 147
  • 1
  • 2
  • 7
5
votes
3 answers

SQLite FTS example doesn't work

I've downloaded the latest SQLite 3.7.15.2 shell (Win32) and tried to execute one of the FTS examples exactly as it is written at http://sqlite.org/fts3.html#section_3 -- Virtual table declaration CREATE VIRTUAL TABLE docs USING fts3(); -- Virtual…
Stan Lagun
  • 53
  • 1
  • 4
4
votes
1 answer

SQLite full text search indexes

I currently have a diagnosis table. I want to make the code and description fields searchable using FTS. As I understand it though, FTS tables don't support indexes and I need to be able to lookup Diagnosis by diagnosisID very quickly. Am I going…
MobileGuy
  • 1,232
  • 1
  • 11
  • 21
4
votes
2 answers

SQLite3 fts3 AUTOINCREMENT not working

I am trying to create a virtual table in sqlite3 using fts3 and having a column as autoincrement but when inserting values, the column is not getting populated. Code: CREATE VIRTUAL TABLE contact USING fts4( id INTEGER PRIMARY KEY…
user704045
  • 41
  • 1
  • 2
4
votes
1 answer

SQLite fts3: search for a string in a column

Is there any way to search for a particular string in a column? I want to search like SELECT * from email_fts WHERE email_fts MATCH 'to:"a@b.com" OR from:"c@d.com"' Thanks in advance, Manoj
ManojMarathayil
  • 712
  • 11
  • 28
4
votes
1 answer

FTS (Full Text Search) sqlite how to implement FTS Table?

I am trying to create an android like application and want to allow for quick searches so was looking into FTS for sqlite for Android. I see how to create it, but was wondering a couple of things: Table_words - my table for words If I create a new…
Lion789
  • 4,402
  • 12
  • 58
  • 96
3
votes
1 answer

System.Data.Sqlite and FTS4

Why when i write a query with fulltext Search syntax like: SELECT * FROM TABLENAME WHERE TABLENAME MATCH 'ColumnA:word1 OR ColumnB:word2' The query result always return 0 rows? I'm using VBnet and the latest Ado.net provider from sqlite.org The…
popa big
  • 31
  • 1
  • 2
1
2
3
…
8 9