On 7/6/05, Steve O'Hara <[EMAIL PROTECTED]> wrote: > > SQLite doesn't have a free text search capability - the Like and Glob > functions are not free text just simple pattern matching on the scanned > text. Performance is very poor because there is no suitable index. > > It's not a simple task to create free text searching - you have to create an > inverted index for every (or all) columns you want to search on, then you > have to find a mechanism to combine that in the SQL parser. The inverted > index means creating a grammar parser and a language specific stemmer to > produce terms with their associated proximity info. The same parser/stemmer > is then used to produce your search terms from the SQL statement. > > I've been creating such a beast for a while with some nice results. The > project stems from an idea of creating published DVD searchable databases of > library content, but I haven't worked on it for ages. > > I was hoping to get it to a point where I could offer it up to the SQLite > community as a side project for development as an add-in to the core code. > At the moment, it's got a VB front end to a VS6.0 DLL but the idea is to > make it an extension of the sqlite3.exe. > > Is there anyone out there that would like to get involved in this? If there > is, I'll happily provide a precise of how it works, what's been done and > what there is still to do.
What is the dll written in? It might be easy to port to C as source others can include in their programs as a user defined function.