Stack Overflow
Stack Overflow

Questions tagged [fts4]

FTS3 and FTS4 are an SQLite virtual table modules that allows 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.

103 questions
0
votes
1 answer

"optimize" command in sqlite fts3 on android makes "MATCH" doesn't work

I am creating a fts4 table in android , I batch insert large number of rows then optimize as recommended in sqlite documentation I use the following code in android public void indexFts() { SQLiteDatabase db = getWritableDatabase(); …
Mohammad Yahia
  • 483
  • 9
  • 19
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
0
votes
1 answer

Need assistance implementing full text search

I have a Note app which running for a while, now I am implementing full text search feature, I read a bout the sqlite fts3 & fts4 modules. I want to know that after creating virtual table for full text search do I have to copy all data from my…
S.J
  • 3,063
  • 3
  • 33
  • 66
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

Read data from FTS table?

In one of implementing feature set application have to perform frequent Search Query directly from sqlite data Base. I found FTS could be better way to perform faster search. I created it but it's returning no data. I checked by opening db file,…
CoDe
  • 11,056
  • 14
  • 90
  • 197
0
votes
1 answer

SQLite Check if Table is FTS4

I'm developing an Android app that uses a SQLite database with FTS4 tables. In the app there's an option to import a database from the external memory. This database needs to be checked to confirm that it has all the correct tables and columns. I…
The Berga
  • 3,744
  • 2
  • 31
  • 34
0
votes
0 answers

What is External Content Table? What is the advantages over normal virtual tables?

What are external content tables and how can they be used instead of fts3 virtual tables for Full Text Search? Is it worth to use fts4 instead of fts3?
Bhushan
  • 205
  • 2
  • 14
0
votes
0 answers

Virtual Table using fts4 not getting created android

I am trying to create a virtual table using fts4 with external content table. The app works fine on API 23 but when I ran it on API 16 it crashed. Create statement : String DDL_FTS_TODO_TABLE = "CREATE VIRTUAL TABLE "+TBL_VIRTUAL_TODO+" USING…
Bhushan
  • 205
  • 2
  • 14
0
votes
0 answers

SQLite FTS4 compound MATCH doesn't work with FMDB (iOS, Objective c)

I have a simple FTS4 query: SELECT * FROM addresses WHERE addresses MATCH '(PLZ:12* OR Nummer:12*) AND (Ort:Berlin*)' This query works fine with SQLiteManager (I get some results), but when I execute this query with FMDB I don't get results (no…
riv333
  • 389
  • 2
  • 12
0
votes
2 answers

SQLite FTS4 external content using view without column names

I'm using FTS4 with sqlite 3.8.10 and I'm trying to set up a schema like so: CREATE TABLE Test (name TEXT); CREATE VIEW TestView as SELECT name FROM Test; CREATE VIRTUAL TABLE TestFTS using FTS4(content="TestView", name); In this toy example, I…
Tim
  • 4,560
  • 2
  • 40
  • 64
0
votes
1 answer

how to query fts tables on android

I am developing for android. I am using reference http://sqlite.org/fts3.html. I create a fts table as final String SQL_CREATE_TABLE_SEARCHABLE =
 new StringBuilder("CREATE VIRTUAL TABLE ")
 …
Katedral Pillon
  • 14,534
  • 25
  • 99
  • 199
0
votes
0 answers

How do you add a SQLite3 created function to an iOS 9 project?

I am trying to build a simple SQLite full text search (FTS4) for an iOS 9/Xcode 7 project w/ Swift 2.2. I am accessing the SQLite3 C API directly with Swift, I see no need to use a bloated wrapper library. I have the full text search working…
DropAcid
  • 61
  • 1
  • 6
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
1 answer

Confusion on SQLite Tables & Virtual Tables

I am currently developing a notebook application for the Android environment, however I am stuck on how to approach a SQL search interface. From conducting research, I have found the most effective approach would be to use the "Full Text Search"…
user5111186
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
1 2 3 4 5
6
7