> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Meeuwissen > > The other point which might be open is that I have no idea > how to speak to the 'vts' functionality. I think it is > impossible through bridge and taglib now.
The org.mmbase.storage.search.implementation.database.vts classes implement a ChainedSqlHandler. In combination with the InformixSqlHandler it enables the Verity Text Search facility to be used. I put it in CVS as a coding example or how to implement a ChainedSqlHandler. In the coming weeks they will be replaced by a similar handler for the Excalibur Text Search engine on Informix, the reason being that the latter will be used in production, and will therefore receive fullscale testing and support (see below). > I tried to add similar functionalities (regexp and fulltext > search) for mysql and postgresql but didn't dare yet to check it in. > > I imagine that > <mm:constraint field="title" operator="~" value="$searchvalue" /> > > would lay an 'regexp' constraint. Databases not supporting > that could fall back to ILIKE '%<value>%' or so. > > And for full-text-search-like functionality we could perhaps > do something similar. Textsearch constraints can already be submitted using StringSearchConstraint. In addition, these constraints can be specified in bridge methods, using the string format supported by the LegacyConstraintParser. See API docs for details. The one thing that is left to do to take advantage of textsearch facilities on your database setup, is implement and configure a ChainedSqlHandler, which is precisely what I'm going to do at the VPRO for their Informix/Excalibur setup. Using that as testcase and proof of concept, we can proceed, e.g. for the MySQL textsearch facilities. Regarding regular expressions: we can add that too if the need is felt. At present the need for textsearch support is much more manifest. Rob van Maris Technical Consultant Quantiq xmedia & communication solutions Koninginneweg 11-13 1217 KP Hilversum T +31 (0)356257211 M +31 (0)651444006 E [EMAIL PROTECTED]
