That's a promising project; I hope it reaches maturity.
I assume your modified tokenizer did a similar thing, like tokenizing "full text search" as [full, text, search, ull, ll, l, ext, xt, xt, earch, arch, rch, ch, h]? What worked and what did not work? Thanks, Paul ________________________________ From: Yongil Jang <yongilj...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thursday, November 8, 2012 2:26 PM Subject: Re: [sqlite] FTS substring behavior How about look at following URL? https://github.com/jonasfj/trilite AFAIK, FTS doesn't support substring search. I also tried to edit FTS to find substring by changing simple tokenizer. It was worked partially, but not a good solution to use generally. 2012/11/9 Dan Kennedy <danielk1...@gmail.com> > On 11/09/2012 01:49 AM, Paul Vercellotti wrote: > >> >> >> Hi there, >> >> I wanted to clarify if FTS could provide any optimization for substring >> matches like '*ion*' or similar? >> > > No. I think it will actually search for tokens that start with the 4 > ASCII characters "*ion" if you try that. > > Dan. > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users