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

[sqlite] Error: database disk image is malformed

2012-08-18 Thread Tal Tabakman
Hi Richard, *Just for getting better understanding* you wrote: " Consider using the "unix-dotfile" VFS instead of the standard "unix" VFS. (Add the string "unix-dotfile" as the 4th argument to sqlite3_open_v2().) The unix-dotfile VFS will use dot-file locking instead of posix advisory