Forum OpenACS Q&A: Improving and synchronizing Search in Oracle and Postgresql versions.

Collapse
1: Improving and synchronizing Search in Oracle and Postgresql versions.
Posted by Dave Bauer on 08/07/02 02:47 AM
I started this thread in the OpenACS 4.0 design forum, but it didn't
last long. I can't believe noone in interested in making this work.

Here is the post that started it:

It looks like we need a plan to get the search packages for Postgresql
and Oracle implementations in line.

While we are at it, we need to come up with ways to limit and organize
search results.

Ideas I have heard so far are limiting search by package and limiting
search by object_type.

Here are the tasks I think are required:

Oracle -Build an FTSEngineDrive service contract implementation for
Intermedia -Port the Search package to Oracle

Postgresql -Port OpenFTS 0.33 to work with AOLserver/OpenACS.

Both databases -Improve search package to allow searching by package,
so forums could offer a "search this forum" feature -Improve search
package to allow searching by object-type, so one could search all
forum messages in any forums package instance, or all bugs in an
bugtracker package instance

If there anything else that might be nice to have, or is critical make
full text searching available across the entire toolkit?

Perhaps we can start a list of people or companies that are interested
in helping to work on search solutions. People with ideas, coders, and
testers will be needed.

And the entire thread:
https://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0005AW&topic_id=12

Thanks.

Collapse
2: Response to Improving and synchronizing Search in Oracle and Postgresql versions. (response to 1)
Posted by Don Baccus on 08/07/02 03:38 AM
The reason it died, IMO, isn't because no one is interested (we should  all be interested) but because it's a large enough task that it needs a champion who will push it forward.

Maybe that should be you? :)  After the new site work is done, of course.  That doesn't mean you have to figure out how to write the code all by yourself or anything like that, of course.

I'd suggest the first thing that needs doing is to build that Oracle service contract implementation and figure out how to hook InterMedia searching up to the new package while not breaking the old sitewide-search package, at least in the near term.