I've committed my resurrection of the original photo.net/ACS
bboard_contains hack. This provides a simple keyword-based search
facility.
It is a stopgap measure only (I've been looking into both swish-e and
swish++ as well) but works OK. I didn't try to be creative but rather
opted to recreate the old PL/SQL (Oracle) bboard_contains function
exactly. You can hack on it further if you want to implement
phrase-based searching (by paying attention to the order in which
words appear in the target), etc.
I rewrote it in PL/Tcl, so you need to build Postgres with the
--with-tcl option. You do not need to stop and restart the postmaster
after rebuilding and reinstalling Postgres with Tcl support (if you
don't have it built in already). Just do a "creatlang pltcl" on your
acs database and things should work. I decided to use PL/Tcl for this
because doing the string searches in PL/pgSQL would be awkward,
and each expression would run through the query executor, which would
be somewhat slow. The PL/Tcl version is short and sweet, and should
be faster, too.
The simple Tcl function is in /doc/sql/rank-for-search.sql. There's a
new parameter "UseOpenACSSearch" which turns on simple searching.
Just update your sources from CVS, psql -f rank-for-search.tcl, turn
on the above-mentioned param, restart AOLserver, and you're off to the
races.
Not very quickly, though - this requires a sequential search of the
bboard table (one reason why I consider this a stopgap measure only).
It is better than nothing, though!
