Also http://code.google.com/apis/gears/api_database.html#sqlite_fts might add some information.
I have an item on my todo list which goes something like "Refactor the FTS docs on the wiki". Unfortunately, it's been on my todo list for a couple months, now, with little progress. -scott On Nov 29, 2007 5:39 AM, P Kishor <[EMAIL PROTECTED]> wrote: > On 11/29/07, Jiri Hajek <[EMAIL PROTECTED]> wrote: > > Hello, > > > > I'm considering usage of FTS, but from the documentation it's a little > > unclear to me what's the recommended way of using it, particularly in > > the following scenario: > > > > Let's say that I already have some database structure containing > > several tables with mixes type of data (some string fields that I > > would like to index by FTS and others that I wouldn't need to index). > > How should I use FTS in this case? Create a new FTS table and store > > all text data there? Would it actually be a duplication, or can FTS > > store only index, without the actual full strings? > > > > You create a new VIRTUAL TABLE and let fts index only the fields that > you want to conduct full-text search against. Your original table with > its columns still remains. > > See <http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex> for a pretty > nice explanation. If that explanation is not clear, please let us know > what is confusing. I will try to make that explanation better. > > -- > Puneet Kishor > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
