Re: [sqlite] FTS Usage

[Scott Hess]

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  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]
-

Re: [sqlite] FTS Usage

[P Kishor]

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  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]
-

[sqlite] FTS Usage

[Jiri Hajek]

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?

Thanks for your help,
Jiri

-
To unsubscribe, send email to [EMAIL PROTECTED]
-