Four Js Development Tools Forum

Discussions by product => Genero BDL => Topic started by: Christina L. on November 04, 2008, 05:27:44 am



Title: Full text Search Engine with Genero
Post by: Christina L. on November 04, 2008, 05:27:44 am
Has anyone implemented a full text search engine with Genero? Preferably on Informix database. Would like to know how is it done.

Thanks.
Christina Lim


Title: Re: Full text Search Engine with Genero
Post by: . on November 04, 2008, 08:17:36 am
In IDS 11 exists a Basic text search engine datablade which allows you to do searches on text data found in char,varchar, lvarchar, blob and clob datatypes.

Regards,

Lars


Title: Re: Full text Search Engine with Genero
Post by: . on November 04, 2008, 08:20:09 am
oh and there is also Informix Excalibur Text Search DataBlade - i'm not sure if its the same as detailed above : http://www-01.ibm.com/software/data/informix/blades/excaliburtext/


Title: Re: Full text Search Engine with Genero
Post by: Christina L. on November 04, 2008, 10:30:37 am
Hi Lars,

The Excalibur is available for IDS Workgroup & Enterprise editions only. I am working with IDS V10 Express edition. Database upgrade can be quite costly. Trying to find a 3rd party search engine that can work with IDS Express.

Alternatively, we can work with MySQL database. Have tried out Sphinx search engine with MySQL and implemented in Ruby-on-Rails. The result is good. However, I do not not know how to implement in Genero.

Appreciate any help.

Thanks.

Christina