On 8/27/08, Andreas Ntaflos <[EMAIL PROTECTED]> wrote:
> Hi list,
>
>  this is my first post to this list and the first time I am using SQLite 
> (3.6.1
>  from source on Debian and Ubuntu) in a program of mine so I obviously don't
>  have much experience with it. I am glad for the documentation (otherwise I
>  would have missed that FOREIGN KEY constraints are ignored and have to be
>  added using triggers) but I am unclear on a few things regarding FTS3 (or
>  full text search in general).
>
>  In particular I'd like to know the best practise on incorporating FTS3 into 
> an
>  existing database schema, possibly already populated with content. There are
>  some fields of some of the tables in the database that should be be full text
>  searchable. How to go about that?
>
>  Obviously I have to create some virtual tables that hold the text that will 
> be
>  searched. But how do I link the virtual tables to the "real" tables so that I
>  know the table and the row in which a field with matching content was found?
>  Do I, every time I insert text into a field, or change the text in a field of
>  the real table, have to programmatically or manually update or change the
>  text in the corresponding virtual table as well?
>
>  As you can see I am not very familiar with how these things are supposed to
>  work. The documentation [1, 2] on the website is fine for explaining FTS
>  itself but I couldn't find anything on how to incorporate FTS into a real
>  application.
>
>  Any advice will be greatly appreciated. If there is any FM I should R kindly
>  point me to it :)

See my notes at

http://www.punkish.org/?p=Why_File_When_You_Can_Full-Text_Search

I should get down to write a new and more detailed version and then
putting it on the SQLite wiki. FTS documentation is woefully
dismembered and scattered.


>
>  Thanks in advance,
>
>  Andreas
>
>  [1] http://www.sqlite.org/cvstrac/wiki?p=FtsUsage
>  [2] http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex
>  --
>  Andreas Ntaflos
>  Vienna, Austria
>
>  GPG Fingerprint: 6234 2E8E 5C81 C6CB E5EC  7E65 397C E2A8 090C A9B4
>  _______________________________________________
>  sqlite-users mailing list
>  sqlite-users@sqlite.org
>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to