Forum OpenACS Development: Improving and Synchronizing Search in Oracle and Postgresql

Collapse
1: Improving and Synchronizing Search in Oracle and Postgresql
Posted by Dave Bauer on 07/03/02 02:32 AM
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.

Collapse
2: Response to Improving and Synchronizing Search in Oracle and Postgresql (response to 1)
Posted by Don Baccus on 07/03/02 03:24 PM
First priority IMO is to write the Oracle SC implementation so we have a uniform base for both RDBMS's.  I'm glad you're bringing up this subject and will be even happier if you can help implement it :)

After we have both RDBMS's finally using the same search package then, yes, improvements such as you suggest are needed.

Collapse
3: Response to Improving and Synchronizing Search in Oracle and Postgresql (response to 1)
Posted by Dave Bauer on 07/03/02 04:38 PM
Don and anyone else,

Is anyone porting the Search package to Oracle?

I looked at it, and I think I can do that work.

Building the intermedia driver is another story.

I looked at that task earlier this year, and was totally lost. I would be willing to work with someone with intermedia experience to get this completed.

Collapse
4: Response to Improving and Synchronizing Search in Oracle and Postgresql (response to 1)
Posted by Yonatan Feldman on 07/03/02 05:16 PM
i ported the search package to oracle last week when i thought i was going to use it for forums search. it is in the development tree. there is only one file (search/www/search.tcl) that needs to be finished. as you said, building the interMedia driver is another story.
Collapse
5: Response to Improving and Synchronizing Search in Oracle and Postgresql (response to 1)
Posted by Peter Vessenes on 07/18/02 04:08 PM
Where's the documentation for extending Intermedia? I'd be happy to at least take a look at it.