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