Forum OpenACS Development: Re: Project to build a new FtsEngineDriver using tsearch2 for PostgreSQL

For support of other non-text formats we would have needed a text version of all indexed non-text content anyway, at least with openfts, because with the current architecture it calls the conversion to text everytime an item shows up as match in the search results page and that is not practicable for documents with expensive conversion processes, e.g. pdfs. With a text copy in the db the search results page wouldn't need to be built as streaming http with ns_write, what a relief!
Storing a text version of the document in the database allows us to send emails with part of the content or have the search page look like google (with a small teaser for the document).