Re: [sqlite] How to know what terms were created using FTS

2012-08-27 Thread Scott Hess
On Sat, Aug 18, 2012 at 10:00 AM, Mohit Sindhwani wrote: > On 17/8/2012 7:14 PM, Dominique Pellé wrote: >> This gives the tokens: >> >> sqlite> CREATE VIRTUAL TABLE ft USING fts4(x); >> sqlite> INSERT INTO ft VALUES("hello world"); >> sqlite> INSERT INTO ft VALUES("hello there");

Re: [sqlite] How to know what terms were created using FTS

2012-08-18 Thread Mohit Sindhwani
Hi Dominique, Thanks! On 17/8/2012 7:14 PM, Dominique Pellé wrote: This gives the tokens: sqlite> CREATE VIRTUAL TABLE ft USING fts4(x); sqlite> INSERT INTO ft VALUES("hello world"); sqlite> INSERT INTO ft VALUES("hello there"); sqlite> CREATE VIRTUAL TABLE ft_terms USING fts4aux(ft);

Re: [sqlite] How to know what terms were created using FTS

2012-08-18 Thread Mohit Sindhwani
On 17/8/2012 6:41 PM, Dan Kennedy wrote: On 08/17/2012 03:58 PM, Mohit Sindhwani wrote: Hi Ralf, On 17/8/2012 3:50 PM, Ralf Junker wrote: On 17.08.2012 09:30, Mohit Sindhwani wrote: We're using FTS4 and it works well for many things. One of the things that we'd like to do is to see what

Re: [sqlite] How to know what terms were created using FTS

2012-08-17 Thread Dominique Pellé
Mohit Sindhwani wrote: > Hi Ralf, > > > > On 17/8/2012 3:50 PM, Ralf Junker wrote: >> >> On 17.08.2012 09:30, Mohit Sindhwani wrote: >> >>> We're using FTS4 and it works well for many things. One of the things >>> that we'd like to do is to see what terms are being created by

Re: [sqlite] How to know what terms were created using FTS

2012-08-17 Thread Mohit Sindhwani
Hi Ralf, On 17/8/2012 3:50 PM, Ralf Junker wrote: On 17.08.2012 09:30, Mohit Sindhwani wrote: We're using FTS4 and it works well for many things. One of the things that we'd like to do is to see what terms are being created by the tokenizer in use. What would be the easiest way to do that?

[sqlite] How to know what terms were created using FTS

2012-08-17 Thread Mohit Sindhwani
Hi, We're using FTS4 and it works well for many things. One of the things that we'd like to do is to see what terms are being created by the tokenizer in use. What would be the easiest way to do that? I tried looking through the fts_aux table and the segments and content tables, but