Re: [sqlite] [FTS] Executing Sql statements inside a custom tokenizer

2012-01-03 Thread Abhinav Upadhyay
> Two FTS tables? One with the Porter stemmer, for search, one without, to > build the auxiliary tables? Yeah, that is the last option, if nothing else works. For a small set of documents the extra processing time might be ok but for a larger set of documents building the FTS tables twice might b

Re: [sqlite] [FTS] Executing Sql statements inside a custom tokenizer

2012-01-03 Thread Petite Abeille
On Jan 3, 2012, at 8:30 PM, Abhinav Upadhyay wrote: > What other options do I have ? Two FTS tables? One with the Porter stemmer, for search, one without, to build the auxiliary tables? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sq

[sqlite] [FTS] Executing Sql statements inside a custom tokenizer

2012-01-03 Thread Abhinav Upadhyay
Hi, I would like to build up a table of all the unique words occurring in my corpus (for spelling suggestion feature). Presently I am using the Porter stemming tokenizer and I would not like to stop using the stemmer at any cost. Although if I was not using the Porter stemmer then I could easily o