The tokens are all there, so it is "theoretically possible". But the performance would be very bad because it would require iterating over all the segment data, basically a worst-case query. Even then, you wouldn't have information about hit counts. To do it reasonably would require redesigning the data format to take this use-case into consideration.
-scott On Wed, Dec 23, 2009 at 3:56 AM, Max Vlasov <[email protected]> wrote: > Is it theoretically possible to allow some kind of sql SELECT query > operations with tokens? > > Particulary one could implement suggestions similar to Google suggestions in > Web search, when for example "some" typed in a search box and a listbox > popped up with this database tokens starting with these letters shown > ("someone", "something" etc). > Having some experience with full-text in past once I did my own simple > implementation of full-text for sqlite, where all tokens saved in a > separated table that also has a text index, so in this case SELECT Title > FROM Tokens WHERE Title LIKE "some%" works as expected (with > case-sensitivity pragma effectively set). I tried to read the technical part > of http://www.sqlite.org/fts3.html document, but could not figure out > whether it is possible to implement this in the current implementation of > fts3 > > Thanks > > Max > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
