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
3
votes
1 answer

Compressing Encrypted SQLite FTS3 Database for iOS

My app uses a SQLite database with FTS3 to do product search. I am trying to encrypt the database using SQLCipher but it causes the database size to balloon (7mb --> ~20mb). It doesn't look like there is a great way to compress an encrypted FTS…
Rangers4me
  • 177
  • 2
  • 9
3
votes
2 answers

SQLite3 FTS3/FTS4 matchinfo example

I am using the FTS4 module of SQLite3 and have a problem with the Example of the matchinfo() auxiliary function. At the moment I am just trying to run the matchinfo() example from http://www.sqlite.org/fts3.html#matchinfo and it does not work. I…
user1228727
  • 31
  • 1
  • 3
3
votes
1 answer

unable to retrieve special characters from sqlite fts3

I am having some problems with special characters in my scenario. I have a sqlite db created using fts3. When I use SELECT col_1, col_2, offsets(table) FROM table WHERE table MATCH 'h*' LIMIT 50; I am able to get words which start with h. but when I…
Arup
  • 384
  • 1
  • 10
3
votes
2 answers

Include partial matches in SQLite FTS3 Search

My simple SQLite FTS3 implementation currently matches user queries with stored results and returns them as long as these results contain all the words in the user query (in other words, the FTS table was created using a simple tokenizer). Now, I…
gc20
  • 61
  • 1
  • 2
  • 5
3
votes
1 answer

SQLite3 multiple FTS tables search

I have three fts virtual tables in my sqlite database - two with one content column, and one with 2 columns - title and content. Say one table is for some articles' content and titles, and other two is for reviews and their notes. Is there some way…
Anonymous
  • 347
  • 2
  • 8
3
votes
1 answer

SQL Delete statement with nested selects

I am trying to make a subquery in a DELETE statement in order to improve performance. The plain DELETE statement works but the subquery ones are either deleting all rows indiscriminately, or only one row per invocation. I am confused as to why the…
chew socks
  • 1,406
  • 2
  • 17
  • 37
3
votes
1 answer

How to query in sqlite fts3 table using "-*"?

I have a fts3 table named tab and a lot of entries in it. When I run this query: SELECT * FROM tab WHERE key MATCH 'an*'; I get the results like this: an anul an- But when I run this query: SELECT * FROM tab WHERE key MATCH 'an-*'; it still…
snecserc
  • 615
  • 1
  • 6
  • 19
3
votes
1 answer

Android Sqlite FTS3 how to select words that starts with?

For example, if i have these records word AAA AAB AAC BAA AA With a normal table i would use sql like select * from table where word like 'AA%'order by H collate nocase asc How do i select with FTS3 table instead? Also i would like to know if FTS3…
Eddi
  • 479
  • 5
  • 22
3
votes
0 answers

How can I create the virtual table using FTS in SQLite

How can I create the virtual table using FTS in SQLite. I have 3 tables, but I don't want to add the columns manually into the table. For example: I have the 3 tables like: t1(t1_id,t1_name), t2(t2_id,t2_name), t3(t3_id,t1_id,t2_id,t3_name) Now,…
Anjali Tunge
  • 139
  • 1
  • 5
3
votes
1 answer

Android sqlite fts3 match and compare integer/float

We have a sqlite fts3 table without enhanced syntax(Android!!!) where we use a query like this: SELECT * FROM tableName WHERE tableName MATCH 'name*' AND validTo > 1389999600000 LIMIT 10 This works fine on iOS with fts4 and enhanced syntax, the…
Morten Holmgaard
  • 7,484
  • 8
  • 63
  • 85
3
votes
0 answers

How to include null values in an SQLite FTS3 Match Query?

I'm programming for the Android, using SQLITE's FTS3 tables (virtual tables). Is there any way to have a query return null values in the same query one uses the MATCH statement? As an example, i have tried the following: Select rowid, Category…
sean262 none
  • 212
  • 2
  • 8
3
votes
1 answer

information storage in sqlite fts3/fts4

Am planning to create a simple search engine in python(python3).Going through the documentation for sqlite fts3/fts4 ,it became my choice to store the documents,since full text searches are fast.I already have a set of webpages ,with their text…
user2078134
  • 47
  • 1
  • 4
3
votes
1 answer

Android sqlite database wait until initial population of data is completed

I'm following the 'Searchable Dictionary' of Android examples and pre-populating my FTS3 database with some data (1200 records). I want to display 3 'default' records on initial load of my activity but I need to wait until all the records have been…
KamyarN
  • 145
  • 2
  • 7
2
votes
3 answers

Multiple Column Match in FTS3

I have a simple database of three columns: title, data, info. I'm storing them in a SQLite FTS3 database so I can easily perform full-text searches. I've been basing my app off the Searchable Dictionary example from Android. The one thing I can't…
Brian
  • 7,955
  • 16
  • 66
  • 107
2
votes
0 answers

Ordinary SQLite vs FTS3 Tables

I have some data that is already organized in an SQLite table for my app. When I wanted to implement search functionality to my app, I found that the Searchable Dictionary example uses a FTS3 virtual table. I've never work with FTS3 and I just want…
Brian
  • 7,955
  • 16
  • 66
  • 107
1 2
3
…
8 9