Forum .LRN Q&A: forums full text search

Collapse
1: forums full text search
Posted by Yonatan Feldman on 07/02/02 04:07 AM

i have committed an initial version of search for forums. it is mostly for oracle although postgres should work. here is the cvs log message: 

added search to forums. oracle version using intermedia, postgres version
simply using like statements for now. forums-search-create.sql and
forums-search-drop.sql aren't sourced automatically since they require manual
loading (must switch schema user at certain points) please follow the
instructions in the file. need to figure out a good way to do this.

does anyone have any ideas on how to make the installation of the search subsystem any cleaner?

Collapse
2: Response to forums full text search (response to 1)
Posted by Dave Bauer on 07/02/02 03:45 PM
This implementation seems to limit the searching just to forums messages.

Are there any plans to integrate the searching of forums into a more general search function? Right now that is site-wide-search for Oracle and search for postgresql.

Collapse
3: Response to forums full text search (response to 1)
Posted by Ben Adida on 07/02/02 03:54 PM
Dave,

site-wide search implementation and forums-specific searching
are, unfortunately, mutually exclusive: site-wide-search does not
allow one to search forums only -- a pretty important feature.
Yes, a site-wide-search hook is important for forums as a whole,
too, and we'll work on that in the near future (unless someone
else wants to take a stab at it first?).

Collapse
4: Response to forums full text search (response to 1)
Posted by Michael Feldstein on 07/02/02 04:06 PM
How feasible/desireable would it be to create a simple search scoping mechanism that worked off of the URL structure or site map? For example, have it only search pages whose URLs begin with "https://openacs.org/bboard/"?

I realize that this isn't an ideal solution for scoping, but might it be an acceptable short-term work-around?

Collapse
5: Response to forums full text search (response to 1)
Posted by Ben Adida on 07/02/02 04:13 PM
Search is not performed with respect to URL schemes. Whole
HTML pages are not what's indexed. The raw database data is.
Thus, the scoping would have to be far more involved.

This is by no means a trivial issue. We should probably discuss
ideas, but I don't expect to see a "simple" scoped solution.

Collapse
6: Response to forums full text search (response to 1)
Posted by Dave Bauer on 07/02/02 04:14 PM
Ah this makes sense.

Unfortunately, i don't have time to work on fixing search or site-wide-search right now. Searching by package is an important feature.