Re: [Fez-developers] Boolean searching / Fulltext indexing

[Christiaan K. <c.k...@li...>]

Hello Kai

I am currently in Paris having a week off for holidays after the SUN PASIG
meeting. I'll be back in Australia next week.

Have you seen my presentation slides? They talk about the fez 2 release and
what will be in fez 2.1:

http://espace.library.uq.edu.au/view.php?pid=UQ:119976

We are certainly going to bring your fulltext code into the Fez trunk, as
soon as we can - possibly in the next couple of weeks.

I am looking very seriously into Postgresql. It provides a much more
powerful fulltext search engine called 'TSearch2'. Also there is a php
parser for google-style and/not/or searching with brackets ()s with the very
nice tsearch2 digital stratum fulltext query parser (php) -
http://digitalstratum.com/oss/fts_parser

However we will continue to support mysql as an equal option for the fez
index RDBMS. We could probably adapt the digital stratum parser to create
sql code for mysql as well as postgresql.

Cheers,
Christiaan 


On 19/11/07 7:47 PM, "Jauslin  Kai" <kai...@li...> wrote:

> Hello Fez developers,
> 
> the current trunk version does not allow boolean searching (AND/OR/NOT) in
> advanced search (e.g. to get all documents from author1 OR author2. Is there a
> plan for implementation?
> 
> What about the integration of our MySQL fulltext indexing into the trunk? It
> runs very well over here, with good performance (our fulltext table currently
> has 11'000 entries). I also did an implementation of highlighting query words
> in fulltext extracts and a document preview for the browse lists. Also this
> runs without much performance penalties.
> 
> The only thing that is not so easily possible with the current implementation
> is the combination of advanced, field based search with complex boolean
> fulltext search. I think for this functionality, another indexing approach
> (e.g. using Zend Lucene) should be used.
> 
> Could you please tell me what you think about these problems and whether there
> is anything going on into that direction?
> 
> Cheers from Zurich, Kai

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christiaan Kortekaas
Senior Library Open Sorcerer
Library Technology Service
The University of Queensland, Australia QLD 4072
Telephone : (+61) (7) 3346 4337
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~