We had this same problem. Went looking for a solution, and came back around to Lucene. I know this is not what you wanted to hear, but Lucene has the kind of search features that users expect, and that we would not find in other packages. I believe both Oracle and MySQL have some sort of text search capability, you might want to check them out. If you come back around to Lucene, let me know maybe I can help.
Richard -----Original Message----- From: Patrick Casey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 9:19 AM To: 'Tapestry users' Subject: [OT] FreeForm Text Search other than Lucene? Sorry for the OTness here, but I find this mailing list has more java knowledge in it than anywhere else I'm likely to look so . I'm considering adding freeform text search to a web application I'm working on. I've done the same thing before with other applications using Lucene, but that approach was, to be blunt, frail because I had to keep (and manage) two parallel data stores. There was Lucene's file based storage listing all the text and object keys, and there was my database that held the objects themselves. Keeping the two in synch through errors, transaction failures, backups, and recoveries was like pulling teeth and never *quite* worked right, resulting in the occasional "oh, just rebuild the whole lucene index" approach to fault recovery. What I'd really like is some form of vendor-neutral freeform text search that uses an RDBMS (not the file system) as its repository. Does anybody know of a java based solution that offers that kind of functionality? --- Pat --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
