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
1
vote
1 answer

Implementing AutoCompleteTextView/SearchView with autosuggestions over large dataset

I would like to ask if my concept of implementing search in my application is correct and whether it could be improved. I will provide any details needed therefore I believe my question is well-suited for this site. I need to implement a search…
syntagma
  • 23,346
  • 16
  • 78
  • 134
1
vote
1 answer

Portability of sqlite database using custom tokenizer

I have a sqlite database, which uses custom tokenizers: Do all clients, which want to read from this database, require the same tokenizer in their sqlite-driver? Or are the internal tokenizer data structures ready to use without implementation of…
Chris
  • 8,031
  • 10
  • 41
  • 67
1
vote
1 answer

SQLite regular table and table for fts

I have table news (id, news_id, news_title) and I creat FTS table: CREATE VIRTUAL TABLE news_search USING fts4 (news_title, tokenize=porter); I use trigger to keep table NEWS and news_search in sync: CREATE TRIGGER IF NOT EXISTS…
Magog
  • 485
  • 4
  • 13
1
vote
1 answer

Sqlite FTS3 MATCH OR

I am using FTS3 in sqlite in an android project. The problem is that when I search for the word "or" the database expect more words. "SELECT * FROM words WHERE Palabra MATCH '"+word+"'"; This works well except when the word is "or". How can I…
Germán Caselles
  • 15
  • 1
  • 4
1
vote
1 answer

using sqlite3 fts3 snippet function in android dictionary app

I have built an android dictionary app using an sqlite3 fts3 virtual table. I would like to be able to execute a search using the fts3 snippet function, as in: SELECT snippet(my_dictionary) FROM my_dictionary WHERE my_dictionary MATCH…
user2271541
  • 21
  • 4
1
vote
1 answer

how to convert an sqllite statement from '=' to MATCH instead

I'm trying to create a dbase solution for email threading. When I receive an email.. I want to know if this email belongs to an existing thread. So I match the subject ie subject = 'cool bro' matches 're: cool bro' and i also want to match the…
abbood
  • 23,101
  • 16
  • 132
  • 246
1
vote
1 answer

Why does SQLite full-text search (FTS4) treat angle brackets differently in a compound search?

I have an SQLite database using FTS4. It is used to store emails with message id's of the form: Searching for messages using the FTS MATCH syntax, I get a result from: SELECT rowid FROM emails WHERE emails MATCH '<8200@comms.io>' This returns the…
Roderick
  • 1,205
  • 11
  • 24
1
vote
1 answer

How to create virtual table for FTS3 with ORMLite

I couldn't find a way to use FTS3 with ormlite because, I have problems creating a virtual table. I need to run something like this in native sqlite: CREATE VIRTUAL TABLE enrondata1 USING fts3(content TEXT); But ORMLite calls the below method for…
Sardor Dushamov
  • 1,665
  • 3
  • 17
  • 44
0
votes
2 answers

FTS3 | rowid problems | delete dont work

I recently updated my database to FTS3 due to that I implented search functionality. My FTS3 table: db.execSQL("CREATE VIRTUAL TABLE " + TABLE_FTS + " USING fts3(" + COL_ID + ", " + COL_KEY_NAME + ", " + COL_KEY_WEBURL + " , " +…
Leandros
  • 16,805
  • 9
  • 69
  • 108
0
votes
1 answer

Aliasing _id in an FTS3 database

My application uses an SQLite database with FTS3. The results of a query shall be displayed in a list view using a SimpleCursorAdapter. However I get the following exception: java.lang.IllegalArgumentException: column '_id' does not exist Doing…
Robert Strauch
  • 12,055
  • 24
  • 120
  • 192
0
votes
1 answer

Can I use the FTS extension for sqlite from within R`?

Sqlite comes with support for full text special tables. Is it possible to use these features from within R, e.g. from RSQLite?
Karsten W.
  • 17,826
  • 11
  • 69
  • 103
0
votes
0 answers

Match keyword (Full Text Search ) not working with SQLite3 C API

I am using SQLite3 C API in an Android App. I want to implement Full Text Search in a Table. Created a Virtual Table in it : create VIRTUAL TABLE IF NOT EXISTS call_record USING fts3(_id int, call_id text not null, caller text not null, recipient…
Nikhil Maheshwari
  • 2,198
  • 18
  • 25
0
votes
0 answers

How to encode SQLite FTS3 strings

I'm working with a SQLite FTS3 table as explained here: https://www.sqlite.org/fts3.html I'm interested in the field end_block, described as: This field may contain either an integer or a text field consisting of two integers separated by a space…
Arnau EC
  • 44
  • 9
0
votes
0 answers

Why is there a segmentation fault with this code?

I couldnt find the tag for apsw module. import sqlitefts as fts import os from search import * from search import OUWordTokenizer import sys def tokenize(): with apsw.Connection('texts.db', flags=apsw.SQLITE_OPEN_READWRITE) as connection: …
Ram Charran
  • 131
  • 1
  • 3
  • 14
0
votes
1 answer

How to register porter tokenizer in python

How is the default tokenizer 'porter' in fts3 module registered. one way to register user defined tokenizers is fts.register_tokenizer() but what are its arguments? since porter being a in built tokenizer does it even need to be registered?
Ram Charran
  • 131
  • 1
  • 3
  • 14
1 2 3
…
8 9