Forum OpenACS Q&A: Response to APM and FTS

Collapse
7: Response to APM and FTS (response to 1)
Posted by Dan Wickstrom on
Openfts is in what is likely to be one of many stages. The openfts developers are experimenting with various features which should eventually result in a full-featured search engine within postgresql.

The latest incarnation has more natural interface which is easier to understand. In the current system, search queries look something like the following:

    SELECT
          txt.tid,
      FROM
          txt
      WHERE
          (txt.fts_index @ '{14054652}')

and the new system that I'm working on porting uses a natural language approach that supports boolean operators and it looks like the following:

select * from foo where titleidx @@ '(the|this)&!we';

This is quite an improvement over the previous approach, and I can't wait to see how openfts evolves.

In any event, Neophytos has stated that he will do the documentation for this new version, and I'm sure that he will include references on how to build it for both 7.1 and 7.2.